
題目鏈接:
183. Customers Who Never Order
解析:
這道題比較簡單,只需要綜合兩個(gè)表使用SELECT查詢語句即可,值的注意的是這是我們第一次使用NOT IN關(guān)鍵字。
題解:
# Write your MySQL query statement below
SELECT Name AS Customers FROM Customers
WHERE Id NOT IN (SELECT CustomerId FROM Orders)
183. Customers Who Never Order
這道題比較簡單,只需要綜合兩個(gè)表使用SELECT查詢語句即可,值的注意的是這是我們第一次使用NOT IN關(guān)鍵字。
# Write your MySQL query statement below
SELECT Name AS Customers FROM Customers
WHERE Id NOT IN (SELECT CustomerId FROM Orders)