List the name of all the distinct customers who have ordered with status "packing"
select distinct t1.customer_name from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t2.order_status = "Packing"
may i have the dates of their orders please?
select distinct t2.date_order_placed from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t2.order_status = "Packing"
may i have the order ids please
select order_id from orders where order_status = "Packing"
may i have the customer ids please
select customer_id from orders where order_status = "Packing"
yes
select order_id from orders where order_status = "On Road"