SQL Duplicate Emails

EasySQL · PostgreSQL

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

CodePostgreSQL

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

Run your query to see results here.