select Email from
(select Email, count(*) as count from person
group by email
having count > 1) as emailcount;
My first accepted like yours.
But this is much simple. Selecting from Person directly, rather a view.
select Email from Person
group by Email
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.