CREATE TABLE Order_Items (product_id VARCHAR2, total_amount_purchased NUMBER)
CREATE TABLE Product_Suppliers (product_id VARCHAR2, total_amount_purchased NUMBER)

Return the ids of all products that were ordered more than three times or supplied more than 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
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