Database: department_store
Question: What is the average price of clothes?
SQL:
SELECT avg(product_price) FROM products WHERE product_type_code  =  'Clothes'