Task: Text to Code
Input (English): Step 1: find the average product_price in Products table.
Step 2: For each row in Products table, find the corresponding rows in Product_Suppliers table.
Step 3: find Product_Suppliers's product_id in the results of step 2 whose product_price greater than the results of step 1
Output (English): SELECT T2.product_id FROM Products AS T1 JOIN Product_Suppliers AS T2 ON T1.product_id = T2.product_id WHERE T1.product_price > ( SELECT Avg ( T1.product_price ) FROM Products AS T1 )