leetcode.183. Customers Who Never Order
来源:互联网 发布:mac 10.12 降级 编辑:程序博客网 时间:2024/05/20 02:26
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 Name as Customers FROM Customers c WHERE c.Id NOT IN (SELECT CustomerId FROM Orders);
0 0
- 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
- Leetcode 183. Customers Who Never Order
- leetcode 183. Customers Who Never Order
- 183. Customers Who Never Order (LeetCode, SQL)
- LeetCode笔记:183. Customers Who Never Order
- leetcode 183. Customers Who Never Order
- LeetCode | Customers Who Never Order
- Leetcode : Customers Who Never Order
- LeetCode Customers Who Never Order
- Leetcode Customers Who Never Order
- Leetcode: Customers Who Never Order
- 【Leetcode】Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- root mac
- java运维
- nyoj 283 对称排序
- FragmentTabHost
- linux中shell截取字符串方法总结
- leetcode.183. Customers Who Never Order
- 暑假培训1 排序
- hdu 5195(拓扑排序+线段树优化)
- swagger
- 管理App的内存
- 0706第七讲标准模版库(2)链表
- 随感
- Gcc编译选项分析
- Acitivity加载模式说起