#22

Difference between highest and lowest card issuance

JPMorgan Chase is preparing a credit card issuance report. For each card, find the difference between the highest and lowest number of cards issued in a month. Return card_name and difference. Sort the result by difference in descending order.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

card_namedifference
Amex Platinum25000
Chase Sapphire20000
Discover It7000
JPMorgan Chase

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid