Task: Text to Code
Input (English): Step 1: find the average total_value_purchased of each value of product_id in Product_Suppliers table.
Step 2: find supplier_id in Product_Suppliers table whose corresponding value in step 1 is greater than 50000
Output (English): SELECT supplier_id FROM Product_Suppliers GROUP BY product_id HAVING Avg ( total_value_purchased ) > 50000