Launch Month Card Volume

SQL practice question · Medium · Date & Time · JPMorgan

product_launches has one row per card launch (card_id, launch_date) and issuance_records has one row per card issued (card_id, issue_date, issue_id). For each launched card, count the cards issued in its first month, defined as issue_date on or after launch_date and no more than 30 days after it (launch_date + 30 days inclusive). Cards with no issues in that window show 0. Output columns: card_id, first_month_issues. Order by card_id ascending.

Table: product_launches

Schema of product_launches
Column	Type
card_id	INTEGER
launch_date	DATE

Schema of product_launches

Column

Type

card_id

INTEGER

launch_date

DATE

Sample rows of product_launches
card_id	launch_date
10	2026-01-01
20	2026-01-15

Sample rows of product_launches

card_id

launch_date

2026-01-01

2026-01-15

Table: issuance_records

Schema of issuance_records
Column	Type
card_id	INTEGER
issue_date	DATE
issue_id	INTEGER

Schema of issuance_records

Column

Type

card_id

INTEGER

issue_date

DATE

issue_id

INTEGER

Sample rows of issuance_records
card_id	issue_date	issue_id
10	2026-01-03	1
10	2026-01-20	2
10	2026-02-02	3
20	2026-01-20	4
20	2026-02-10	5

Sample rows of issuance_records

card_id

issue_date

issue_id

2026-01-03

2026-01-20

2026-02-02

2026-01-20

2026-02-10

Expected output on the sample data
card_id	first_month_issues
10	2
20	2

Expected output on the sample data

card_id

first_month_issues

Solve it in the live editor on this page — run on sample data, then submit against hidden tests.

Tech Town

Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Question Asked in Interview Blog

SQL Interview Practice

Company-wise SQL questions

{{ totalCount }} questions in the style asked at Amazon, Microsoft, Google, Meta, Flipkart and more — {{ hardPct }}% Hard. Write SQL in a real database engine in your browser, run it on sample data, then evaluate against hidden tests.

🏆 Weekly SQL Contest

Questions

Companies

Solved

Bookmark Question Companies Difficulty Category Status

{{ r.n }} - {{ r.title }}

No questions match these filters.

Showing {{ rangeLabel }} of {{ filteredCount }}

Company tags show where this type of question is commonly reported in interviews. Questions, data and solutions are written by TechTown.

Daily challenge

{{ daily.title }} · {{ daily.difficulty }} Solve now

New question every day at midnight IST.

Your Progress

Reset all SQL practice progress{{ resetScope }}? This can't be undone.

{{ p.label }} ({{ p.pct }}%){{ p.solved }}/{{ p.total }}

Points: {{ myPoints }} · Easy 10 · Medium 20 · Hard 40

🔥 Longest streak: {{ streak.longest }}Current streak: {{ streak.current }}

Leaderboard (rolling 100 days)

Loading…

{{ u.rank }} {{ u.name }}{{ u.points }} pts

← All questions

{{ cur.n }} - {{ cur.title }}

🏆 Contest {{ contestWeek }}

Embed this questionPaste on a blog, course page or LMS. Free to use — educator guide

{{ embedCode }}

Table: {{ tb.name }}

ColumnType

Expected output on the sample data:

No submissions yet. Press Evaluate to submit your query.

The solution unlocks after you solve this question or after 3 evaluations that didn't pass ({{ failCount }}/3 so far). Trying first is the fastest way to learn.

{{ solutionSql }}

SQL dialect ⏱ {{ timerLabel }}

{{ fnHelpTitle }}
{{ fnHelpText }}

Writing {{ dialectName }} · Ctrl/Cmd + Enter runs the query · Tab indents · your code is saved automatically

Output

{{ out.error }}

Expected (sample data)

Your output (sample data)

Run your query to see the result here.

🔒

To Track Your Progress, Log In / Sign Up

You have solved your 3 free questions — nice work! Log in (free) to unlock all 150 questions, keep your streak and appear on the leaderboard.