Task: Text to Code
Input (English): Step 1: find the number of rows of each value of product_id in Product_Suppliers table.
Step 2: find product_id in Product_Suppliers table whose corresponding value in step 1 is greater than 3.
Step 3: find the product_id of Product_Suppliers table for which total_value_purchased less than 80000.
Step 4: show the rows that are in any of the results of step 2 or the results of step 3
Output (English): SELECT product_id FROM Product_Suppliers GROUP BY product_id HAVING Count ( * ) > 3 UNION SELECT product_id FROM Product_Suppliers WHERE total_value_purchased < 80000