Community Heath Metrics
You work at Stack Overflow on the community team that monitors the health of the platform.
Community members can create a post to ask a question, and other users can reply with answers or comments to that question. The community can express their support for the post by upvoting or downvoting.
Example:
Input:
post_analytics table
| Column | Type | Description |
|---|---|---|
id |
INTEGER | Primary key of posts table |
user_id |
INTEGER | ID of the user who created the post |
created_at |
DATETIME | Timestamp of the post |
title |
VARCHAR | Title of the post |
body |
VARCHAR | Text content of the post |
comment_count |
INTEGER | Total number of the comments on a post |
view_count |
INTEGER | Total number of the views on a post |
answer_count |
INTEGER | Total number of answers on a post |
upvotes |
INTEGER | Total number of upvotes on the post |
Given a table of Stack Overflow posts data, suggest three metrics to monitor the health of the community.
Write the queries for these metrics in SQL.
.....
Loading editor