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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.