What are the ids of all products that were either ordered more than 3 times or have a cumulative amount purchased of above 80000?
select product_id from order_items group by product_id having count(*) > 3 union select product_id from product_suppliers group by product_id having sum(total_amount_purchased) > 80000