Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Write a SQL query to find the number of posts that have more comments than the average number of comments per post.
You will be using instagram_posts table that has the following columns:
| Column Name | Description |
|---|---|
| post_id | Unique identifier for each post |
| user_id | ID of the user who created the post |
| comments | Number of comments on the post |
| nb_posts |
|---|
Write a SQL query to find the number of posts that have more comments than the average number of comments per post.
You will be using instagram_posts table that has the following columns:
| Column Name | Description |
|---|---|
| post_id | Unique identifier for each post |
| user_id | ID of the user who created the post |
| comments | Number of comments on the post |
| nb_posts |
|---|
| 22 |
| 22 |