The compliance department needs a report of all cards that have expired. Return card id, account_id, card_number, card_type, and expiry_date for cards where the status is 'expired'. Sort by expiry_date ascending.
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