Database: customers_and_products_contacts
Question: Show the product name and total order quantity for each product.
SQL:
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