183. Customers Who Never Order
来源:互联网 发布:粒子群算法 详解 ppt 编辑:程序博客网 时间:2024/06/05 02:24
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 Name AS 'Customers' FROM Customers WHERE Customers.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
- 预处理程序学习与分析(一)
- Linux网络接口配置文件解析
- 刷题训练——PAT (Basic Level)-1039
- ListView 返回顶部第一条
- 无法解析的外部符号, 但是已经添加的lib库
- 183. Customers Who Never Order
- Hadoop-2.7.3下安装Hbase-1.2.6
- 382. Linked List Random Node
- FreeRTOS 低功耗之 tickless 模式
- MySql中 delimiter 详解
- git操作
- 关于freemarker静态化处理spring国际化标签报错解决办法
- 浏览器输入url到整个页面显示出来经历的过程
- Django教程之三-----编写你的第一个Django 应用(1)