leetcode 183. Customers Who Never Order
来源:互联网 发布:diy美工刀架 编辑:程序博客网 时间:2024/06/03 03:07
183. Customers Who Never Order
- Total Accepted: 21129
- Total Submissions: 64940
- Difficulty: Easy
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 |+-----------+
Subscribe to see which companies asked this question
# Write your MySQL query statement belowselect c.Name as Customersfrom Customers cwhere not exists (select * from Orders o where o.customerId=c.id)
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
- 每天一题 leetcode-8 String to Integer (atoi)
- TCP长连接与短连接的区别
- 文章标题AngularJS学习
- Android Design Support之TabLayout实战
- 上楼梯(动态规划)
- leetcode 183. Customers Who Never Order
- 【C/C++】结构体和联合体的区别
- statement的四个执行方法---executeQuery/executeUpdate/execute/executeBatch---和早期数据库防黑技术
- 刘汝佳白书 10-3-4危险的组合(统计(数位dp))
- Spring MVC 深入及对注解的详细讲解
- linux【进程学习】笔记——PCB、进程环境、进程原语、虚拟地址……
- 菲波拉契数列的通项公式
- POJ 2155 (二维树状数组)
- hadoop面试百题