Detect Duplicate User Accounts | Dataford Interview Questions

Given a database schema for user profiles, write a SQL query to find duplicate accounts based on email addresses.

Treat only identical, non-null email values as duplicates. Return one row per duplicated email address.

Output

user_profiles

Column	Type	Description
user_idPK	INT	Unique identifier for the user profile
full_name	VARCHAR(255)	User's full name
email	VARCHAR(255)	Email address associated with the profile

Your question is Detect Duplicate User Accounts. Start with the requirements and the one table in the Question tab.

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

Given a database schema for user profiles, write a SQL query to find duplicate accounts based on email addresses.

Treat only identical, non-null email values as duplicates. Return one row per duplicated email address.

user_profiles

Column	Type	Description
user_idPK	INT	Unique identifier for the user profile
full_name	VARCHAR(255)	User's full name
email	VARCHAR(255)	Email address associated with the profile

Your question is Detect Duplicate User Accounts. Start with the requirements and the one table in the Question tab.

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