Could you tell me the name of the customer that made the order that had the largest quantity of items in it?
select t1.customer_name from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id join order_items as t3 on t2.order_id = t3.order_id where t3.order_quantity = ( select max ( order_quantity ) from order_items )
What dates did they become customers?
select t1.customer_name, t1.date_became_customer from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id join order_items as t3 on t2.order_id = t3.order_id where t3.order_quantity = ( select max ( order_quantity ) from order_items )
Can you list the names of all customers who cancelled at least one order as well as the order dates of those cancelled orders?
select t1.customer_name, t2.order_date from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id where t2.order_status = "Cancelled"
What are the order quantities and dates for all orders that were paid for with cash?
select t3.order_quantity, t2.order_date from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id join order_items as t3 on t2.order_id = t3.order_id where t1.payment_method = "Cash"