What are the product names with average product price smaller than 1000000?
CREATE TABLE PRODUCTS (Product_Name VARCHAR, Product_Price INTEGER)
[SQL] SELECT Product_Name FROM PRODUCTS GROUP BY Product_Name HAVING AVG(Product_Price) < 1000000 [/SQL]