C# Online Compiler | .NET Fiddle

using System;
using System.Collections.Generic;
using System.Linq;

public class Program
{
    public static void Main()
    {
        List<PlayerPerformance> playerPerformances = new List<PlayerPerformance>
        {
            new PlayerPerformance { PlayerID = 1, PlayerName = "John Doe", Team = "A", GameDate = new DateTime(2023, 3, 10), PointsScored = 22, Rebounds = 5, Assists = 7 },
            new PlayerPerformance { PlayerID = 2, PlayerName = "Jane Smith", Team = "B", GameDate = new DateTime(2023, 3, 10), PointsScored = 15, Rebounds = 4, Assists = 10 },
            new PlayerPerformance { PlayerID = 3, PlayerName = "Emily Jones", Team = "A", GameDate = new DateTime(2023, 3, 11), PointsScored = 30, Rebounds = 7, Assists = 5 },
            new PlayerPerformance { PlayerID = 4, PlayerName = "Michael Brown", Team = "B", GameDate = new DateTime(2023, 3, 11), PointsScored = 18, Rebounds = 8, Assists = 11 },
            // Add more player performance entries as needed
        };

        // Step 1: Calculate the total points scored, total rebounds, and total assists for each team
        var teamStats = playerPerformances
            .GroupBy(p => p.Team)
            .Select(g => new
            {
                Team = g.Key,
                TotalPointsScored = g.Sum(p => p.PointsScored),
                TotalRebounds = g.Sum(p => p.Rebounds),
                TotalAssists = g.Sum(p => p.Assists)
            })
            .ToList();

        // Step 2: Identify the team with the highest average points scored per game
        var teamWithHighestAveragePoints = teamStats
            .Select(t => new
            {
                t.Team,
                AveragePoints = t.TotalPointsScored / playerPerformances.Count(p => p.Team == t.Team)
            })
            .OrderByDescending(t => t.AveragePoints)
            .First();

        Console.WriteLine($"Team with Highest Average Points Scored: {teamWithHighestAveragePoints.Team}, Average Points: {teamWithHighestAveragePoints.AveragePoints}");

        // Step 3: For the team identified in step 2, find the player who contributed the most to the team's average points scored
        var topPlayerInTeam = playerPerformances
            .Where(p => p.Team == teamWithHighestAveragePoints.Team)
            .OrderByDescending(p => p.PointsScored)
            .First();

        Console.WriteLine($"Top Scoring Player in {teamWithHighestAveragePoints.Team}: {topPlayerInTeam.PlayerName}, Points Scored: {topPlayerInTeam.PointsScored}");
    }
}

public class PlayerPerformance
{
    public int PlayerID { get; set; }
    public string PlayerName { get; set; }
    public string Team { get; set; }
    public DateTime GameDate { get; set; }
    public int PointsScored { get; set; }
    public int Rebounds { get; set; }
    public int Assists { get; set; }
}

 
using System;
using System.Collections.Generic;
using System.Linq;
​
public class Program
{
    public static void Main()
    {
        List<PlayerPerformance> playerPerformances = new List<PlayerPerformance>
        {
            new PlayerPerformance { PlayerID = 1, PlayerName = "John Doe", Team = "A", GameDate = new DateTime(2023, 3, 10), PointsScored = 22, Rebounds = 5, Assists = 7 },
            new PlayerPerformance { PlayerID = 2, PlayerName = "Jane Smith", Team = "B", GameDate = new DateTime(2023, 3, 10), PointsScored = 15, Rebounds = 4, Assists = 10 },
            new PlayerPerformance { PlayerID = 3, PlayerName = "Emily Jones", Team = "A", GameDate = new DateTime(2023, 3, 11), PointsScored = 30, Rebounds = 7, Assists = 5 },
            new PlayerPerformance { PlayerID = 4, PlayerName = "Michael Brown", Team = "B", GameDate = new DateTime(2023, 3, 11), PointsScored = 18, Rebounds = 8, Assists = 11 },
            // Add more player performance entries as needed
        };
​
        // Step 1: Calculate the total points scored, total rebounds, and total assists for each team
        var teamStats = playerPerformances
            .GroupBy(p => p.Team)
            .Select(g => new
            {
                Team = g.Key,
                TotalPointsScored = g.Sum(p => p.PointsScored),

Cached Result

\file03\Wholesale_Solutions\Statements\Checked\Archive\2015