183. Customers Who Never Order

最新推荐文章于 2024-10-08 11:31:42 发布

SDS_19

最新推荐文章于 2024-10-08 11:31:42 发布

阅读量108

点赞数

分类专栏： MySQL LeetCode 文章标签： mysql leetcode

本文链接：https://blog.csdn.net/SDS_19/article/details/118823513

版权

MySQL 同时被 2 个专栏收录

12 篇文章 0 订阅

订阅专栏

LeetCode

7 篇文章 0 订阅

订阅专栏

Problem: 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.

SELECT CustomerId FROM Orders;

+------------+
| CustomerId |
+------------+
| 3          |
| 1          |
+------------+

SELECT Name Customers FROM Customers WHERE Id NOT IN (SELECT CustomerId FROM Orders);