Skip to main content
All Problems
medium0% acceptance

Customers Who Opened Accounts on the Same Day

Find pairs of different customers who opened an account on the same date. Return customer1_id, customer2_id, and the shared opened_at date. Ensure each pair appears only once (customer1_id < customer2_id). Order by opened_at, then customer1_id.

Schema

🔑idINT
🔗customer_idINT
account_typeTEXT
balanceREAL
currencyTEXT
opened_atTEXT
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute