Your question is Daily Engagement Rate by Post Date. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |