Task: Text to Code
Input (English): SQL: SELECT product_name , Sum ( product_price ) FROM Products GROUP BY product_id
Feedback: Use product name instead of product id and order quantity instead of product price .
Output (English): SELECT T1.product_name ,  sum(T2.order_quantity) FROM products AS T1 JOIN order_items AS T2 ON T1.product_id  =  T2.product_id GROUP BY T1.product_id