Skip to main content
All Problems
medium0% acceptance

Accounts Opened on the Same Day as Another

The fraud team wants to find accounts that were opened on the same day as at least one other account. Return account id, customer_id, account_type, and opened_at. Sort by opened_at, then id.

Schema

🔑idINT
🔗customer_idINT
account_typeTEXT
balanceREAL
currencyTEXT
opened_atTEXT
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute