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"
counting customers with a specific order status (\"On Road\") involves joining two tables (customers and orders) on a common field (customer_id); the specific order status is specified in the WHERE clause (order_status = \"On Road\"); the COUNT function is used to get the total number of matching records.