Search query types in the `book_query_types` table using SQL

[MayHyeyeonKim]

SELECT * FROM public.book_query_types
WHERE query_type = 'ItemNewAll'
ORDER BY book_id ASC, query_type ASC;

SELECT * 
FROM public.book_query_types
WHERE query_type = 'ItemNewSpecial'
ORDER BY book_id ASC, query_type ASC;

SELECT * 
FROM public.book_query_types
WHERE query_type = 'Bestseller'
ORDER BY book_id ASC, query_type ASC;

SELECT * 
FROM public.book_query_types
WHERE query_type = 'BlogBest'
ORDER BY book_id ASC, query_type ASC;

SELECT * 
FROM public.book_query_types
WHERE query_type = 'ItemEditorChoice'
ORDER BY book_id ASC, query_type ASC;

[MayHyeyeonKim]

Retrieve the distinct query types available in the book_query_types table

SELECT DISTINCT query_type 
FROM public.book_query_types
ORDER BY query_type ASC;