Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.