Detect Duplicate Accounts | Dataford Interview Questions

Write a SQL query to identify potential duplicate Robinhood accounts based on matching IP addresses and sign-up timestamps.

Use the robinhood_accounts table. Treat two different accounts as a potential duplicate pair only when both values are present and exactly match.

Output

One row per potential duplicate account pair.
Include account_id_1, account_id_2, ip_address, and signed_up_at.
Order by ip_address, signed_up_at, account_id_1, and account_id_2 ascending.

robinhood_accounts

Column	Type	Description
account_idPK	INT	Unique Robinhood account identifier
ip_address	VARCHAR(45)	IP address recorded during account sign-up
signed_up_at	TIMESTAMP	Timestamp when the account was created

Your question is Detect Duplicate 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.

Write a SQL query to identify potential duplicate Robinhood accounts based on matching IP addresses and sign-up timestamps.

Use the robinhood_accounts table. Treat two different accounts as a potential duplicate pair only when both values are present and exactly match.

One row per potential duplicate account pair.
Include account_id_1, account_id_2, ip_address, and signed_up_at.
Order by ip_address, signed_up_at, account_id_1, and account_id_2 ascending.

robinhood_accounts

Column	Type	Description
account_idPK	INT	Unique Robinhood account identifier
ip_address	VARCHAR(45)	IP address recorded during account sign-up
signed_up_at	TIMESTAMP	Timestamp when the account was created

Your question is Detect Duplicate 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.