LeetCode-Duplicate Emails

select Email from
(
  select Email, count(Email) as num
  from Person
  group by Email
) as statistic
where num > 1
;

group by 和 having

select Email
from Person
group by Email
having count(Email) > 1;