Your question is Get Duplicate Emails Query. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Ion's Wallstreet Suite client-account data may contain duplicate contact email addresses. Write a PostgreSQL query that identifies normalized email addresses appearing more than once among contacts linked to active client accounts.
client_contacts to client_accounts using account_id.ACTIVE.| Column | Type | Description |
|---|---|---|
| contact_idPK | INT | Unique contact identifier |
| account_id | INT | Identifier of the linked client account |
| full_name | VARCHAR(100) | Contact's full name |
| email_address | VARCHAR(255) | Contact email address |
| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique client account identifier |
| account_code | VARCHAR(30) | Wallstreet Suite account code |
| account_status | VARCHAR(20) | Current lifecycle status of the account |