SQL Duplicate Emails

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL Duplicate Emails. Start with the requirements and the one table on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

Amazon account data may contain duplicate email addresses because of inconsistent capitalization or accidental leading and trailing spaces. Write a PostgreSQL query to identify emails associated with more than one user.

Requirements

Normalize emails by removing leading and trailing whitespace and converting them to lowercase.
Exclude NULL and empty email values.
Return each normalized duplicate email and the number of users sharing it.
Sort the results alphabetically by normalized email.

Schema

users

Column	Type	Description
user_idPK	INTEGER	Unique Amazon user identifier
email	VARCHAR(320)	User email address
created_at	TIMESTAMP	Account creation timestamp

Tablesusers

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results