183. Customers Who Never Order
来源:互联网 发布:美国手机音乐软件 编辑:程序博客网 时间:2024/06/03 17:49
Suppose that a website contains two tables, the Customers
table and theOrders
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 |+-----------+
Subscribe to see which companies asked this question.
MySQL
# Write your MySQL query statement belowselect cs.Name as Customersfrom Customers csleft outer join ( select CustomerId from Orders group by CustomerId ) oson cs.Id = os.CustomerIdwhere os.CustomerId is null;
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
- Mac安装homebrew介绍
- 那些TensorFlow上好玩的和黑科技
- 计算机程序语言与英语
- day55_电力项目_lucene在检索中的应用
- 3. Longest Substring Without Repeating Characters
- 183. Customers Who Never Order
- (转载)JAVA设计模式之工厂模式(简单工厂模式+工厂方法模式)
- hdu1242(Rescue)深搜
- hdu 3980 Paint Chain (sg函数 )
- Spring boot data JPA数据库映射关系 : @OneToOne,@OneToMany,@ManyToMany
- Java —— MessageFormat类 处理国际化
- PDFrenderer
- SO_REUSEADDR套接字选项
- 有一个二维数组. 数组的每行从左到右是递增的,每列从上到下是递增的. 在这样的数组中查找一个数字是否存在。 时间复杂度小于O(N)