Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You just joined a large social media company and you're being ask to analyze the user engagement on the platform.
Write an SQL query to count the total number of likes & comments that occurred in 2021.
user_activity table:
| Column Name | Dimension |
|---|---|
| user_id | integer |
| post_id | integer |
| activity_type | varchar |
| activity_date | date |
You just joined a large social media company and you're being ask to analyze the user engagement on the platform.
Write an SQL query to count the total number of likes & comments that occurred in 2021.
user_activity table:
| Column Name | Dimension |
|---|---|
| user_id | integer |
| post_id | integer |
| activity_type | varchar |
| activity_date | date |
| total_likes_comments |
|---|
| 24 |
| total_likes_comments |
|---|
| 24 |