Community Health Metrics
Start Timer
0:00:00
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.
Recommended questions for you
Personalized based on your user activity, skill level, and preferences.
.
.
.
.
.
.
.
.
.
Comments