Skip to main content
All Problems
easy0% acceptance

List All Blocked Cards

The fraud department needs a list of all blocked cards. Return the card id, card_number, card_type, and issued_at for every card with status 'blocked'. Sort by issued_at 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