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.channel, total_impressions, total_clicks, and avg_spend.avg_spend to exactly two decimal places.DATE '2024-01-01' and exclusive of DATE '2024-02-01'.NULL aggregate results, including total_clicks when all contributing values are NULL.| 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 |