StreamLine, a social media platform, wants a daily engagement report for its content team. Write a SQL query to calculate the daily engagement rate using likes, shares, and comments from a single table of post metrics.
post_datelikes + shares + commentstotal_engagements / impressions * 100post_date is NULLpost_date, total_likes, total_shares, total_comments, total_impressions, and engagement_ratepost_date ascending| Column | Type | Description |
|---|---|---|
| idPK | INT | Unique row identifier |
| post_date | DATE | Date the post was published |
| likes | INT | Number of likes for the post |
| shares | INT | Number of shares for the post |
| comments | INT | Number of comments for the post |
| impressions | INT | Number of impressions for the post |
| post_type | VARCHAR(20) | Content format |