What about top 3 largest?
select product_id from product_suppliers order by total_amount_purchased desc limit 3
And what about the lowest 3?
select product_id from product_suppliers order by total_amount_purchased asc limit 3