#0025

Customers With No Orders

EasySQL12 min10 XP

Problem

Write a SQL query that returns customer names for customers who have never placed an order.

Anti-joins appear constantly in analytics: inactive users, missing payments, abandoned carts, and unmatched records.

customers(id, name)
orders(id, customer_id, amount)

Example 1

Inputcustomers: (1, "Asha"), (2, "Ben"); orders: (1, 1, 500)

OutputBen

Asha has an order. Ben has no matching order row.

CodeSQL

SELECT
  -- write your columns here
FROM customers c
-- write your join here

SELECT
  -- write your columns here
FROM customers c
-- write your join here

Visible browser tests run here when available.

Testcases1 visible / 3 hidden categories

One inactive customer

Input2 customers, 1 order for customer 1

Expectedcustomer 2 only

The left join creates NULL order fields for customers without orders.

Hidden Test Categories

No customers without ordersAll customers without ordersCustomer with multiple orders