Community Engagement Metrics

As a member of Stack Overflow's community team, your role involves assessing the platform's engagement and activity metrics. Users can initiate posts by posing questions, while others can contribute by providing answers or comments. Community support is reflected through upvotes and downvotes. Example: Input: post_analytics table Column Type Description id INTEGER Primary key of the posts table user_id INTEGER ID of the user who created the post created_at DATETIME Timestamp when the post was created title VARCHAR Title of the post body VARCHAR Text content of the post comment_count INTEGER Total number of comments on the post view_count INTEGER Total number of views on the post answer_count INTEGER Total number of answers on the post upvotes INTEGER Total number of upvotes on the post Using the Stack Overflow posts data table, propose three metrics that effectively measure community engagement. Formulate the SQL queries to extract these metrics.