List the order cancelled customer id from the table?
select order_id ,customer_id from customer_orders where order_status = 'Cancelled'
Which order id has the least quantity on the list?
select order_id from order_items order by order_quantity limit 1
How many customer ids has the "delivered" status on the list?
select count ( customer_id ) from customer_orders where order_status = 'Delivered'