从不订购的客户

地址:https://leetcode-cn.com/problems/customers-who-never-order/

## 某网站包含两个表,Customers 表和 Orders 表。编写一个 SQL 查询,找出所有从不订购任何东西的客户。    
     示例:
    Customers 表:
    
    +----+-------+
    | Id | Name  |
    +----+-------+
    | 1  | Joe   |
    | 2  | Henry |
    | 3  | Sam   |
    | 4  | Max   |
    +----+-------+
    Orders 表:
    
    +----+------------+
    | Id | CustomerId |
    +----+------------+
    | 1  | 3          |
    | 2  | 1          |
    +----+------------+
    例如给定上述表格,你的查询应返回:
    
    +-----------+
    | Customers |
    +-----------+
    | Henry     |
    | Max       |
    +-----------+
 
`解题思路`

1 not in

    `select Name as Customers from Customers where id not in (
         select CustomerId from Orders
     )`
     
2left join on

        `select c.Name as Customers from Customers c left join Orders  o on 
         c.Id = o.CustomerId where CustomerId is null`
    

 

上一篇:放弃在QT小游戏里面嵌入Q-learning的python脚本,用C++实现了Q-learning与游戏交互


下一篇:Learning from Sparse and Delayed Rewards with a Multilayer Spiking Neural Network