Skip to main content
All Problems
hard0% acceptance

Find Duplicate Patient Emails

Data quality check: find all patients who share an email address with at least one other patient. Return the email, patient id, first name, and last name for each duplicate. Order by email, then by id.

Schema

🔑idINT
first_nameTEXT
last_nameTEXT
date_of_birthTEXT
genderTEXT
emailTEXT
phoneTEXTNULL
blood_typeTEXT
cityTEXT
stateTEXT
🔗insurance_idINTNULL
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute