Skip to main content
All Problems
easy0% acceptance

High-Balance Active Accounts

The wealth management team wants to identify high-value clients. Find all accounts with a balance greater than 50000 that have a status of 'active'. Return the account id, account_type, and balance.

Schema

🔑idINT
🔗customer_idINT
account_typeTEXT
balanceREAL
currencyTEXT
opened_atTEXT
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute