yokostan / Leetcode-Solutions

Doing exercise on Leetcode. Carry on!
0 stars 3 forks source link

Leetcode #183. Customers Who Never Order #214

Open yokostan opened 5 years ago

yokostan commented 5 years ago
# Write your MySQL query statement below
SELECT c.Name as Customers
FROM Customers c
WHERE NOT EXISTS (
    SELECT Id 
    FROM Orders
    WHERE c.Id = CustomerId
)