- 从不订购的客户:某网站包含两个表,Customers 表和 Orders 表。编写一个 SQL 查询,找出所有从不订购任何东西的客户。
# Write your MySQL query statement below
SELECT Customers.Name as Customers
FROM Customers
LEFT JOIN orders
on Customers.Id <=> orders.CustomerId
WHERE orders.CustomerId IS NULL;
# Write your MySQL query statement below
SELECT Customers.Name as Customers
FROM Customers
LEFT JOIN orders
on Customers.Id <=> orders.CustomerId
WHERE orders.CustomerId IS NULL;