Show me all the products.
select * from products
What is the average price of all products?
select avg(product_price) from products
What is the average price of all products whose type is Clothes.
select avg(product_price) from products where product_type_code = 'Clothes'