Finding Duplicate Records

The Pattern

SELECT columns, COUNT(*) as count
FROM table
GROUP BY columns
HAVING COUNT(*) > 1

Your Task

Find duplicate emails (people who appear multiple times):

• Group by cleaned email (lowercase, trimmed)
• Show emails with more than 1 occurrence
• Show: email, duplicate_count
• Order by count descending