Skip to main content
All Problems
easy0% acceptance

Active Checking Accounts

A bank auditor needs a list of all checking accounts that are currently active. Return the account id, customer_id, balance, and opened_at for every account where account_type is 'checking' and status is 'active'. Order by balance descending.

Schema

🔑idINT
🔗customer_idINT
account_typeTEXT
balanceREAL
currencyTEXT
opened_atTEXT
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute