What is the most common type code of all the products?
select product_type_code from products group by product_type_code order by count ( * ) desc limit 1
What are the product names of all products with the type code "Food"?
select product_name from products where product_type_code = "Food"
What are the prices of those?
select product_price from products where product_type_code = "Food"
What are the names and prices of all products with the type code books?
select product_name, product_price from products where product_type_code = "Books"
What are the name and type code of the product with the highest price?
select product_name, product_type_code from products order by product_price desc limit 1
Can you list all product names and their corresponding type codes of the products with prices below the average price?
select product_name, product_type_code from products where product_price < ( select avg ( product_price ) from products )