Find pairs of patients who share the same first_name, last_name and birth_date. Return the columns: patient_id_1, name_1, patient_id_2, name_2, birth_date (each pair must appear only once and a patient must not be paired with themselves).
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Join the table to itself, and make sure each pair appears only once.