_183. Customers Who Never Order.md

183. Customers Who Never Order

All prompts are owned by LeetCode. To view the prompt, click the title link above.

Back to top

---

First completed : May 22, 2024

Last updated : July 01, 2024

---

Related Topics : Database

Acceptance Rate : 70.1 %

---

Solutions

• e183.sql

SQL

e183.sql

SELECT
    name AS 'Customers'
FROM
    Customers c LEFT JOIN Orders o ON c.id = o.customerId
WHERE 
    o.customerId IS NULL;