What is the total amount purchased for each product?
select product_id, total_amount_purchased from product_suppliers
List the ids of products in decreasing order of their total amount purchased.
select product_id from product_suppliers order by total_amount_purchased desc
Just give me the top three.
select product_id from product_suppliers order by total_amount_purchased desc limit 3