Orders With Missing Customers
Programming Interview
Medium
6 views
Problem Description
Tables: Orders(order_id, customer_id), Customers(customer_id). List orders whose customer_id does not exist in Customers.
Input Format
SQL tables are described in the question.
Output Format
Write the SQL query.
Official Solution
SELECT o.order_id
FROM Orders o
LEFT JOIN Customers c ON c.customer_id=o.customer_id
WHERE c.customer_id IS NULL;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!