BrightAds wants a simple monthly view of marketing performance from its campaign delivery table. Write a SQL query to summarize campaign results for January 2024.
channel for campaigns with campaign_date in January 2024.total_clicks in descending order.| Column | Type | Description |
|---|---|---|
| campaign_idPK | INT | Unique campaign record identifier |
| channel | VARCHAR(50) | Marketing channel |
| campaign_name | VARCHAR(100) | Campaign name |
| campaign_date | DATE | Date the campaign ran |
| impressions | INT | Number of impressions |
| clicks | INT | Number of clicks |
| spend | DECIMAL(10,2) | Campaign spend amount |
| region | VARCHAR(50) | Campaign region |