Premium problem42. Launch Month Growth

Medium Locked

card_issuance(card_name, issue_month, issued_count)

For each card, find its earliest month in the table and return the percent change in issued_count from that launch month to the month that follows it in the data.

Return card_name, launch_month and month2_growth_pct rounded to two decimals, ordered by card_name. Cards with only one month are left out.

"The following month" means the next month present for that card, which is not always the next calendar month.

Tables

card_issuance

card_name  issue_month  issued_count
---------  -----------  ------------
Chase      2026-01-01   1000
Chase      2026-02-01   1500
Chase      2026-03-01   1200
Gap Card   2026-01-01   400
Gap Card   2026-04-01   300
Solo       2026-05-01   900

Expected result

card_name  launch_month  month2_growth_pct
---------  ------------  -----------------
Chase      2026-01-01    50.00
Gap Card   2026-01-01    -25.00

Premium problem

This one's part of Premium. Unlock the full MySQL track plus every other premium problem on the site.

Write one SELECT query