LeeCode(Database)-Customers Who Never Order
来源:互联网 发布:java web登录次数限制 编辑:程序博客网 时间:2024/05/16 06:58
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 |+-----------+
# Write your MySQL query statement belowSELECT Customers.Name as Customers FROM Customers where Customers.Id not in (select Orders.CustomerId from Orders)
0 0
- LeeCode(Database)-Customers Who Never Order
- LeeCode(Database)-Customers Who Never Order
- [LeetCode][Database]Customers Who Never Order
- 【Leetcode】 database Customers Who Never Order
- [Leetcode] [Database] Customers Who Never Order解题
- Database Leetcode Customers Who Never Order
- LEETCODE database 183. Customers Who Never Order
- 【leetcode Database】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 | Customers Who Never Order
- Leetcode : Customers Who Never Order
- LeetCode Customers Who Never Order
- Leetcode Customers Who Never Order
- Leetcode: Customers Who Never Order
- lucene学习笔记
- beego api
- 程序猿写的剧本?你见过了??哈哈_快来看我的原创电影剧本《烽火连三月》前二十个场景
- python笔记2 python对象的动态类型
- javascript 常用代码技巧大收集
- LeeCode(Database)-Customers Who Never Order
- 设计一个二人五子棋游戏
- [汇编学习笔记][第十一章标志寄存器]
- 15. 3Sum
- Android开发在ADT中关联源码
- POJ 1681 Painter's Problem (高斯消元)
- centos 局域网时间同步设置
- c++第四次作业
- Python处理Excel(二):个性化Excel表格