You have customers_email table which has only one column email_id. Find duplicate email_ids.
Asked in the technical round stage. SQL
email_id, duplicate_countduplicate_count descending, then email_id ascendingNULL as a valid email_id value and count its occurrences like any other value.| Column | Type | Description |
|---|---|---|
| email_id | VARCHAR(255) | Customer email address |