FIND THE CUSTOMER NAME AND DATE OF THE ORDERS THAT HAVE THE STATUS "DELIVERED"
select t1.customer_name, t2.order_date from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id where order_status = "Delivered"
WHAT ARE THE CUSTOMER ID FOR ALL THE CUSTOMERS WHOSE ORDERS WERE CANCELLED?
select distinct customer_id from customer_orders where order_status = 'Cancelled'
what are the names of the customers whose customer details are null?
select distinct t1.customer_name from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id where order_details = 'NULL'