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

Customers Who Never Ordered

Easy Joins

Find the names of customers who have never placed an order.

Table schema

Customers(id INT PRIMARY KEY, name VARCHAR(50))
Orders(id INT PRIMARY KEY, customer_id INT)

Sample data

Customers:
id | name
1 | Aman
2 | Riya
3 | Karan

Orders:
id | customer_id
1 | 1
2 | 1
3 | 3

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.