Skip to main content
All Problems
easy0% acceptance

Credit Cards Ordered by Credit Limit

List all credit cards with their credit limit. Return the card id, card_number, credit_limit, and status for cards where card_type is 'credit' and credit_limit is not null. Order by credit_limit descending.

Schema

🔑idINT
🔗account_idINT
card_numberTEXT
card_typeTEXT
expiry_dateTEXT
statusTEXT
credit_limitREALNULL
issued_atTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute