EasyMarketing8 min

Lead status buckets

Challenge

Map each lead status onto the bucket sales uses.

Business context

The CRM stores new, qualified, customer, and disqualified. The sales standup says Open, Working, Won, and Lost.

Instructions

Return id, email, and bucket. new becomes Open, qualified becomes Working, customer becomes Won, and disqualified becomes Lost. Sort by created_at, then id.

Schema

campaigns

id INTEGER · primary key
name TEXT
channel TEXT
spend INTEGER · dollars
started_on TEXT

leads

id INTEGER · primary key
campaign_id INTEGER
email TEXT
status TEXT · new, qualified, customer, disqualified
created_at TEXT

Sample rows

campaigns
id	name	channel	spend	started_on
1	Spring Search	paid_search	4200	2025-03-01
2	Lifecycle Email	email	800	2025-03-01
3	Podcast Tour	podcast	2500	2025-04-01

leads
id	campaign_id	email	status	created_at
1	1	ada@example.com	new	2025-03-05
2	1	ada@example.com	qualified	2025-03-08
3	2	lin@example.com	new	2025-03-11

Draft saves automatically

Ctrl or Cmd + Enter runs the query. The database resets on every run.

Run the query to see rows from the sample database.

Next exercise: Open payables by vendor