Orders With Missing Customers

Orders With Missing Customers

Medium Programming Interview DBMS 24 views
Explanation Complexity

Problem Statement

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.

Input / Output Format

Input Format
SQL tables are described in the question.
Output Format
Write the SQL query.

Example Solution (Public)

Programming Interview 
SELECT o.order_id
FROM Orders o
LEFT JOIN Customers c ON c.customer_id=o.customer_id
WHERE c.customer_id IS NULL;

Official Solution Code

SELECT o.order_id
FROM Orders o
LEFT JOIN Customers c ON c.customer_id=o.customer_id
WHERE c.customer_id IS NULL;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.