Find the details of all distinct customers who have orders with status "On Road".
SELECT DISTINCT T1.customer_details FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id  =  T2.customer_id WHERE T2.order_status  =  "On Road"
distinct customers who have orders with status 'On Road' involves joining customers table with orders table on customer_id and filtering with order_status = 'On Road';