Explore the dim_campaigns table and understand campaign attributes
Before the standup — can you pull a list of all our campaigns? I need to see the campaign name, channel, and status for each one. Just want to see the full picture of what we've been running.
| Column | Type | Key |
|---|---|---|
| campaign_id | INT | PK |
| campaign_name | TEXT | |
| channel | TEXT | |
| start_date | TEXT | |
| end_date | TEXT | |
| budget | REAL | |
| status | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Campaigns live in one dimension table. Alex asked for three specific columns — spell out only those, don’t `SELECT *`.
There are only 9 campaigns, so no LIMIT needed — just SELECT the three columns FROM dim_campaigns
Make sure you're selecting exactly 3 columns — `campaign_name`, `channel`, `status` — not using SELECT *