Credit Card Issuance Gap

SQLEasyJunior levelJPMorgan~15 min

Problem

**[Asked at JPMorgan Chase]**

The bank issues credit cards every month. For each card product, the volume issued
varies — some months are big, others slow.

Find the **difference** between the highest and lowest monthly issuance for each card.
This spread reveals which products have the most volatile demand.

Return `card_name` and `issuance_difference`, ordered from largest difference to smallest.

Tables

Example rows — the live problem includes the full dataset.

monthly_issuance

issuance_id	card_name	issued	issue_month	issue_year

Expected output

Your answer should return 3 rows with the columns card_name, issuance_difference.

Starter code (SQL)

SELECT *
FROM monthly_issuance;

Solve this SQL question free

Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.

Solve it now → Create free account

Solution & explanation

Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.