Customers Who Never Order
1）乍眼一看不难，但是陷阱在答案还替换了表名，最基本的答案是按照题目的逻辑走：
select Customers.Name as Customers from Customers where Id not in (select distinct CustomerId from Orders);
2）表名的修改也可以这个样子改
select Name Customers from Customers where id not in (select DISTINCT CustomerId from Orders);
一、题目 二、个人思考 1）乍眼一看不难，但是陷阱在答案还替换了表名，最基本的答案是按照题目的逻辑走：select...
LeetCode 183. Customers Who Never Order 题目 Suppose that a...
183. 从不订购的客户[https://leetcode-cn.com/problems/customers-w...
leetcode数据库类型：183.从不订购的客户，难度：简单 解答： 这道题使用子查询和NOT IN子句，如果我...
~$python Python 3.6 5 |Anaconda custom (64-bit)| [GCC 7.2...
Leetcode python answers for leetcode
584. 寻找用户推荐人[https://leetcode-cn.com/problems/find-custom...
本机环境 MacOS Python 2.7.15 :: Anaconda custom (64-bit) mysq...
183. Customers Who Never Order Description Suppose that a...
Python 3.5.3 :: Anaconda custom (64-bit)安装keras包 我们用anaco...
本文标题：[LeetCode By Python] 183. Custom
本文链接：https://www.haomeiwen.com/subject/ecrxdttx.html
网友评论