List all the customer orders in the "Cancelled" status.
select * from customer_orders where order_status = "Cancelled"
Find the order quantity for these orders.
select 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"
Find the total quantity of products associated with those orders.
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"