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