Database: customers_and_orders
Question: What is the average price for products with type Clothes?
SQL:
SELECT avg(product_price) FROM Products WHERE product_type_code  =  "Clothes"