Skip to main content
All Problems
easy0% acceptance

List All Expired Cards

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