Members Who Held a Pass but Never Checked In

Problem

Table: `passes`

| Column Name | Type |
|---|---|
| member_id | int |
| valid_from | date |
| valid_to | date |

There is no unique single column. Each row is a gym pass a member held between `valid_from` and `valid_to` inclusive.

Table: `checkins`

| Column Name | Type |
|---|---|
| member_id | int |
| visit_date | date |

There is no unique single column. Each row records a day a member entered the gym.

Count how many distinct members held a pass that was valid at any point during the year 2022 (the pass overlaps the window 2022-01-01 to 2022-12-31) yet never checked in during 2022. Return one column named `inactive_members`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns inactive_members.

Starter code (SQL)

SELECT *
FROM passes;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium