SELECT
email,
COUNT
(
email
)
AS
NumOccurrences
FROM
users
GROUP
BY
email
HAVING
(
COUNT
(
email
)
>
1
)