Database: customers_and_addresses
Question: What is the total number of products that are in orders with status "Cancelled"?
SQL:
SELECT sum(t2.order_quantity) FROM customer_orders AS t1 JOIN order_items AS t2 ON t1.order_id  =  t2.order_id WHERE t1.order_status  =  "Cancelled"