Find Orphan Records
Medium
Data Cleaning
Return the ids of orders that reference a customer who does not exist. Order by id.
Table schema
Customers(id INT PRIMARY KEY, name VARCHAR(50))
Orders(id INT PRIMARY KEY, customer_id INT)Sample data
Customers: ids 1, 2
Orders: (1, customer 1), (2, customer 3), (3, customer 2)
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.