Task: Text to Code
Input (English): SQL: SELECT DISTINCT customer_name FROM Customers ORDER BY customer_id Asc
Feedback: Also need to make sure Customer Orders's order status code equals pending for customers .
Output (English): SELECT DISTINCT T1.customer_name FROM customers AS T1 JOIN customer_orders AS T2 ON T1.customer_id  =  T2.customer_id WHERE T2.order_status_code  =  "Pending" ORDER BY T2.customer_id