What is the id of products supplied more than 80000?
select product_id from product_suppliers group by product_id having sum ( total_amount_purchased ) > 80000
Supplied to.
select date_supplied_to from product_suppliers where supplier_id = 4 order by date_supplied_to desc limit 1