Leetcode Note: Mysql - Customers Who Never Order

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

• MySQL で取り組んだメモ

所感

• わからん

回答

Three accepted solutions - LeetCode Discuss
https://leetcode.com/problems/customers-who-never-order/discuss/53579/Three-accepted-solutions

SELECT Name as Customers FROM Customers
WHERE Id NOT IN (SELECT CustomerId FROM Orders)

• AS カラム名やテーブル名に別名をつける