Skip to main content
All Problems
medium0% acceptance

Cards with Account Information

The card services team needs a list of all active cards along with the associated account type and current balance. Return card_number, card_type, account_type, and balance. Only include cards with status 'active'.

Schema

🔑idINT
🔗customer_idINT
account_typeTEXT
balanceREAL
currencyTEXT
opened_atTEXT
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute