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