Hello!  How many customers have an order status of "On Road"?
select count ( * ) from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t2.order_status = "On Road"
Great! Of those 8 customers, how many also have the status of "Shipped"?
select count ( * ) from ( 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" intersect select t1.customer_name from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t2.order_status = "Shipped" )
Can you please list the name of that 1 customer please?
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" intersect select t1.customer_name from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t2.order_status = "Shipped"