NOT IN pitfall with nulls (safe version)

NOT IN pitfall with nulls (safe version)

Medium SQL Subqueries 16 views
Explanation Complexity

Problem Statement

Find customers who did not place any order. Use NOT EXISTS (safer than NOT IN).

Input Format

SQL query

Output Format

Result set

Example

Customers, Orders
Customer list

Constraints

Handle NULL safely

Input / Output Format

Input Format
SQL query
Output Format
Result set
Constraints
Handle NULL safely

Examples

Input:
Customers, Orders
Output:
Customer list

Example Solution (Public)

SQL 
SELECT c.customer_id, c.name FROM Customers c WHERE NOT EXISTS (SELECT 1 FROM Orders o WHERE o.customer_id = c.customer_id);

Official Solution Code

SELECT c.customer_id, c.name FROM Customers c WHERE NOT EXISTS (SELECT 1 FROM Orders o WHERE o.customer_id = c.customer_id);
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.