CREATE TABLE products (product_type_code VARCHAR, product_price INT)

What is the average price for each type of product?
SELECT product_type_code, AVG(product_price) FROM products GROUP BY product_type_code
SELECT "product_type_code", AVG("product_price") FROM "products" GROUP BY "product_type_code"