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
Show the product name and total order quantity for each product.
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
Show the product name and total order quantity for each product .