183. Customers Who Never Order
来源:互联网 发布:adobeair是什么软件 编辑:程序博客网 时间:2024/05/21 10:49
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
.
+----+-------+| Id | Name |+----+-------+| 1 | Joe || 2 | Henry || 3 | Sam || 4 | Max |+----+-------+
Table: Orders
.
+----+------------+| Id | CustomerId |+----+------------+| 1 | 3 || 2 | 1 |+----+------------+
Using the above tables as example, return the following:
+-----------+| Customers |+-----------+| Henry || Max |+-----------+
SELECT c.Name AS Customers
FROM Customers cWHERE c.Id
NOT IN
(SELECT CustomerId FROM Orders);
0 0
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- LEETCODE database 183. Customers Who Never Order
- leetcode 183. Customers Who Never Order
- leetcode.183. Customers Who Never Order
- 【leetcode Database】183. Customers Who Never Order
- leetcode 183. Customers Who Never Order
- C++开源代码项目汇总
- AES加密 - iOS与Java的同步实现
- String中hashCode分析
- 数据库(第一范式,第二范式,第三范式)
- 线性判别分析LDA算法
- 183. Customers Who Never Order
- Android 出现多种问题的解决
- 数据库设计三大范式
- iOS appstore预览图片的要求
- Manage Android dependencies versions using gradle extra properties.
- 干货| 针对实际数据做机器学习的相关处理
- React 语法之let和const命令
- sg-uap 安装
- 理解OAuth 2.0