Demonstrate how you would use a pivot table to identify trends in this provided dataset.
Use the provided OpenX ad-performance tables and return one row for every listed channel, including channels without activity. Compare January, February, and March 2025 totals to classify the overall trend from January to March.
channel_name, january_impressions, february_impressions, march_impressions, and trend.trend must be Increasing, Declining, or Stable.| Column | Type | Description |
|---|---|---|
| channel_idPK | INT | Unique advertising channel identifier |
| channel_name | VARCHAR(100) | Display name of the advertising channel |
| Column | Type | Description |
|---|---|---|
| performance_idPK | INT | Unique performance record identifier |
| channel_id | INT | Advertising channel identifier |
| report_date | DATE | Date covered by the performance record |
| impressions | INT | Number of served ad impressions |