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
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 <table_name> : Products col : product_id | product_type_code | product_name | product_price row 1 : 1 | Hardware | Apple | 54753982.574522 row 2 : 2 | Clothes | jcrew | 30590929.528306 row 3 : 3 | Hardware | Apple | 10268.85297069 row 4 : 4 | Hardware | Apple | 22956668.699482 row 5 : 5 | Clothes | jcrew | 5927021.8748021 row 6 : 6 | Hardware | Apple | 77.1099611475 row 7 : 7 | Hardware | Apple | 450.392325205 row 8 : 8 | Hardware | Sony | 4446237.9177554 row 9 : 9 | Clothes | jcrew | 622.7927598449 row 10 : 10 | Hardware | Sony | 7171.5933353284 row 11 : 11 | Clothes | jcrew | 149.9551907694 row 12 : 12 | Clothes | gucci | 593.8051992998 row 13 : 13 | Clothes | gucci | 11388.26282462 row 14 : 14 | Hardware | Sony | 389.9154264433 row 15 : 15 | Clothes | gucci | 310488248.48788 <table_name> : Order_Items col : order_item_id | order_id | product_id | order_quantity row 1 : 1 | 9 | 15 | 3 row 2 : 2 | 8 | 12 | 7 row 3 : 3 | 11 | 9 | 9 row 4 : 4 | 15 | 2 | male row 5 : 5 | 13 | 3 | 3 row 6 : 6 | 3 | 6 | 4 row 7 : 7 | 7 | 4 | 8 row 8 : 8 | 6 | 2 | 7 row 9 : 9 | 3 | 15 | 2 row 10 : 10 | 4 | 12 | 5 row 11 : 11 | 14 | 11 | 8 row 12 : 12 | 6 | 2 | 7 row 13 : 13 | 7 | 5 | 9 row 14 : 14 | 5 | 13 | 4 row 15 : 15 | 7 | 3 | 8
col : product_name | sum(T2.order_quantity) row 1 : jcrew | 14 row 2 : Apple | 11 row 3 : Apple | 8 row 4 : jcrew | 9 row 5 : Apple | 4 row 6 : jcrew | 9 row 7 : jcrew | 8 row 8 : gucci | 12 row 9 : gucci | 4 row 10 : gucci | 5