SELECT Product_Name FROM PRODUCTS GROUP BY Product_Name HAVING avg(Product_Price)  <  1000000
Find the product names whose average product price is below 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
Find the product names whose average product price is below 1000000 .