数据库leetcode 182

数据库

#按照Email进行分组，然后统计大于1的email、进行输出

SELECT Email 
FROM Person 
group by Email  
having count(email)>1

2.

先将表进行自粘接，然后统计出来两个表中相同的email是否有不同的id，如果有，证明是的
SELECT distinct a.email
FROM Person a join Person b on a.email = b.email and a.id !=b.id

SELECT distinct a.email
FROM Person a join Person b 
where a.email = b.email and a.id !=b.id

183题

SELECT name customers 
from Customers left join orders on Customers.id = orders.Customerid 
where orders.id is null