C# Online Compiler | .NET Fiddle

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

public class Program
{
    public static void Main()
    {
        List<IncidentReport> incidentReports = new List<IncidentReport>
        {
            new IncidentReport { ReportID = 1, Region = "North", IncidentType = "Theft", Timestamp = new DateTime(2023, 3, 10), SeverityLevel = 3 },
            new IncidentReport { ReportID = 2, Region = "South", IncidentType = "Vandalism", Timestamp = new DateTime(2023, 3, 11), SeverityLevel = 2 },
            new IncidentReport { ReportID = 3, Region = "East", IncidentType = "Theft", Timestamp = new DateTime(2023, 3, 12), SeverityLevel = 4 },
            new IncidentReport { ReportID = 4, Region = "West", IncidentType = "Arson", Timestamp = new DateTime(2023, 3, 13), SeverityLevel = 5 },
            new IncidentReport { ReportID = 5, Region = "North", IncidentType = "Theft", Timestamp = new DateTime(2023, 3, 14), SeverityLevel = 4 },
            // Additional incident report entries as needed
        };

        // Step 1: Calculate the total number of incidents and the average severity level for each incident type
        var incidentStats = incidentReports
            .GroupBy(ir => ir.IncidentType)
            .Select(g => new
            {
                IncidentType = g.Key,
                TotalIncidents = g.Count(),
                AverageSeverity = g.Average(ir => ir.SeverityLevel)
            })
            .ToList();

        // Step 2: Identify the incident type with the highest average severity level
        var highestSeverityIncidentType = incidentStats
            .OrderByDescending(isl => isl.AverageSeverity)
            .First();

        Console.WriteLine($"Incident Type with Highest Average Severity: {highestSeverityIncidentType.IncidentType}, Average Severity: {highestSeverityIncidentType.AverageSeverity}");

        // Step 3: For the incident type identified in step 2, find the region with the most incidents of this type
        var regionWithMostIncidents = incidentReports
            .Where(ir => ir.IncidentType == highestSeverityIncidentType.IncidentType)
            .GroupBy(ir => ir.Region)
            .Select(g => new { Region = g.Key, Count = g.Count() })
            .OrderByDescending(g => g.Count)
            .First();

        Console.WriteLine($"Region with Most {highestSeverityIncidentType.IncidentType} Incidents: {regionWithMostIncidents.Region}, Total Incidents: {regionWithMostIncidents.Count}");
    }
}

public class IncidentReport
{
    public int ReportID { get; set; }
    public string Region { get; set; }
    public string IncidentType { get; set; }
    public DateTime Timestamp { get; set; }
    public int SeverityLevel { get; set; }
}

 
using System;
using System.Collections.Generic;
using System.Linq;
​
public class Program
{
    public static void Main()
    {
        List<IncidentReport> incidentReports = new List<IncidentReport>
        {
            new IncidentReport { ReportID = 1, Region = "North", IncidentType = "Theft", Timestamp = new DateTime(2023, 3, 10), SeverityLevel = 3 },
            new IncidentReport { ReportID = 2, Region = "South", IncidentType = "Vandalism", Timestamp = new DateTime(2023, 3, 11), SeverityLevel = 2 },
            new IncidentReport { ReportID = 3, Region = "East", IncidentType = "Theft", Timestamp = new DateTime(2023, 3, 12), SeverityLevel = 4 },
            new IncidentReport { ReportID = 4, Region = "West", IncidentType = "Arson", Timestamp = new DateTime(2023, 3, 13), SeverityLevel = 5 },
            new IncidentReport { ReportID = 5, Region = "North", IncidentType = "Theft", Timestamp = new DateTime(2023, 3, 14), SeverityLevel = 4 },
            // Additional incident report entries as needed
        };
​
        // Step 1: Calculate the total number of incidents and the average severity level for each incident type
        var incidentStats = incidentReports
            .GroupBy(ir => ir.IncidentType)
            .Select(g => new
            {
                IncidentType = g.Key,

Cached Result

OrderDetailID	OrderID	ProductID	Quantity
1	10248	11	12