SELECT T1.customer_id 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_id FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.order_status = "Shipped"
Find the id of the customers who have order status both "On Road" and "Shipped".
SELECT T1.customer_id 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_id FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.order_status = `` Shipped ''
select t1 . customer_id from customers as t1 join orders as t2 on t1 . customer_id = t2 . customer_id where t2 . order_status = value intersect select t1 . customer_id from customers as t1 join orders as t2 on t1 . customer_id = t2 . customer_id where t2 . order_status = value
Find the id of the customers who have order status both `` On Road '' and `` Shipped '' .