SELECT *, COUNT(*) AS totaal FROM customers GROUP BY email HAVING totaal > 1

SELECT * FROM customers GROUP BY email HAVING COUNT(*) > 1