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