The product ids of all products whose prices are above the average product price are listed.
select product_name from products where product_price> ( SELECT avg ( product_price )  from products ) 
product ids of products whose prices are above average refers to product_price > AVG(product_price);