Difference between highest and lowest card issuance
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. Your answer must use the same column names as this sample — alias them with AS if needed.
| card_name | difference |
|---|---|
| Amex Platinum | 25000 |
| Chase Sapphire | 20000 |
| Discover It | 7000 |
JPMorgan Chase
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid