SELECT Product_Name FROM PRODUCTS GROUP BY Product_Name HAVING avg(Product_Price)  <  1000000
What are the product names with average product price smaller than 1000000?
SELECT Product_Name FROM PRODUCTS GROUP BY Product_Name HAVING avg ( Product_Price ) < 1000000
select product_name from products group by product_name having avg ( product_price ) < value
What are the product names with average product price smaller than 1000000 ?