Show me all the orders with status "On Road"
select * from orders where order_status = "On Road"
Who made those orders?
select t1.customer_name from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t2.order_status = "On Road"
Show me the distinct customer names.
select distinct t1.customer_name from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t2.order_status = "On Road"