Customers Who Never Ordered

LEFT JOINNULL CheckFiltering

Problem Statement

Find all customers who have never placed an order. Return their names sorted alphabetically.

Schema

CREATE TABLE Customers (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL
);
CREATE TABLE Orders (
  id INTEGER PRIMARY KEY,
  customer_id INTEGER,
  amount REAL,
  order_date TEXT
);

Complexity

TimeO(n + m)

Asked By

LeetCode ClassicAmazonShopify

Ready to solve?

Write and run your SQL query in the browser.