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"
The requirement is to find the name of the customer whose orders are both 'On Road' and 'Shipped'. The SQL query achieves this by performing an INTERSECT operation between two subqueries. The first subquery selects customer names with orders 'On Road', and the second selects names with orders 'Shipped'. The INTERSECT operation ensures that only names present in both subqueries are returned, effectively finding customers whose orders have both statuses.