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.
Each hint you reveal reduces the XP you can earn. Try the query first.
All campaign info is in `dim_campaigns`. Alex only needs 3 columns: `campaign_name`, `channel`, and `status`
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 *