59
1
using System;
2
using System.Collections.Generic;
3
using System.Linq;
4
5
public class Program
6
{
7
public static void Main()
8
{
9
List<Post> posts = new List<Post>
10
{
11
new Post { PostID = 1, UserID = 1, Timestamp = new DateTime(2023, 3, 10), ContentLength = 120, EngagementCount = 15 },
12
new Post { PostID = 2, UserID = 1, Timestamp = new DateTime(2023, 3, 11), ContentLength = 300, EngagementCount = 25 },
13
new Post { PostID = 3, UserID = 2, Timestamp = new DateTime(2023, 3, 12), ContentLength = 150, EngagementCount = 5 },
14
new Post { PostID = 4, UserID = 2, Timestamp = new DateTime(2023, 3, 13), ContentLength = 200, EngagementCount = 8 },
15
new Post { PostID = 5, UserID = 1, Timestamp = new DateTime(2023, 3, 14), ContentLength = 500, EngagementCount = 30 },
16
// Add more post entries as needed
17
};
18
19
// Step 1: Calculate the average content length and total engagement count for each user
20
var userStats = posts
21
.GroupBy(p => p.UserID)
22
.Select(g => new
23
{
24
UserID = g.Key,
Cached Result
Roslyn 2.0 Compiler; Environment version: 4.0.30319.42000
John Smith
John Smith
John Smith
John Smith