描述
Suppose that a website contains two tables, the Customers
table and the Orders
table. Write a SQL query to find all customers who never order anything.
Table: Customers
.
1 | +----+-------+ |
Table: Orders.
1 | +----+------------+ |
Using the above tables as example, return the following:
1 | +-----------+ |
分析
两张表,一张 Customer,一张 Orders,通过这两张表找出没有订购过商品的顾客。
解决方案(MySQL)
1 | # Write your MySQL query statement below |