Count each email once, whatever its case or spacing (petition)
The same address appears as Amara@Mail.example and ' amara@mail.example'. Build a clean list of unique emails.
- Level
- intermediate
- Time
- ~7 min
- Task
- Build the query
- Access
- Pro
Checking your access…
About this exercise
What you'll practise
Normalise a key before removing duplicates.
The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.
Input
- Entries (table)
- Email: text
Expected output columns
Email (text)