0183-customers-who-never-order.sql

-- 183. Customers Who Never Order
-- https://leetcode.com/problems/customers-who-never-order

-- Write your MySQL query statement below
SELECT
  name as 'Customers'
FROM
  customers
WHERE
  id NOT IN
  (
    SELECT customerid FROM Orders
  )
;