How do you find duplicate emails with a count?

Short answer: GROUP BY Email HAVING COUNT(*) > 1.

Sample solution

SELECT Email, COUNT(*) AS Cnt
FROM Employees
GROUP BY Email
HAVING COUNT(*) > 1
ORDER BY Cnt DESC;

HAVING filters groups; WHERE filters rows before grouping — say that clearly.