← Interviews
QUESTION
Duplicate emails
+50 XP
Professor Owl
Duplicate emails
Before migrating the CRM, repeated records need to be detected.
Goal
Show each email that appears more than once in customers and how many times it appears.
Key facts
- Tables: employees, customers, orders
- Difficulty: Easy
⏳ Preparing data…
What the database returns
Run your query and the rows will appear here.
🎯 You solve it when your query returns exactly what the goal asks for.