SELECT product_type_code, AVG(product_price) FROM products GROUP BY product_type_code
Berapa harga rata -rata untuk setiap jenis produk?
CREATE TABLE products (product_type_code VARCHAR, product_price INTEGER)