#3 most askedVery commonEasyJoins

Customers Who Never Ordered

🏢 Asked in real interviews

No reports yet. Were you asked this? Be the first to say where.

Tables customers(id, name, city, signup_date, referred_by) and orders(id, customer_id, order_date, status, amount).

Return the name of every customer who has never placed an order.

🧪 Practice

Write the query, then press Run tests to compare your rows with the expected result.

SELECT *
FROM customers;

Output appears here. Press Run or Ctrl/⌘ + Enter.

Try it first. Struggling for a few minutes is how it sticks.