using System;

using System.Collections.Generic;

using System.Linq;

public class Program

{

    public static void Main()

    {

        var status = new List<Neighbourhood>{

            new Neighbourhood{

                Name = "Cherryhood",

                Id = 1,

                Orders = new List<Order>{

                    new Order{

                        Id = 300,

                        OrderItems = new List<string>{

                            "Salad",

                            "Taco",

                            "Pizza"

                        }

                    },

                    new Order{

                        Id = 301,

                        OrderItems = new List<string>{

                            "Cake",

                            "Taco",

                            "Pasta",

                            "Burger"

                        }

                    },

                    new Order{

                        Id = 302,

                        OrderItems = new List<string>{

                            "Salad",

                            "Pasta"

                        }

                    }

                }

            },

            new Neighbourhood{

                Name = "Newcastle",

                Id = 1,

                Orders = new List<Order>{

                    new Order{

                        Id = 400,

                        OrderItems = new List<string>{

                            "Salad",

                            "Taco",

                            "Pizza"

                        }

                    },

                    new Order{

                        Id = 401,

                        OrderItems = new List<string>{

                            "Cake",

                            "Taco",

                            "Pasta"

                        }

                    },

                    new Order{

                        Id = 402,

                        OrderItems = new List<string>{

                            "Salad",

                            "Pasta"

                        }

                    }

                }

            }

        };

        Console.WriteLine($"Neighbourhoods: {status.Count}");

        foreach(var neighbourhood in status){

            Console.WriteLine($"Neighbourhood: {neighbourhood.Name}");

            Console.WriteLine($"Total Orders: {neighbourhood.Orders.Count}");

​

            var allOrderItems = neighbourhood.Orders.SelectMany(i => i.OrderItems).ToList();

            Console.WriteLine($"Total Ordered Items: {allOrderItems.Count}");

            var groupedOrderItems = allOrderItems

                .GroupBy(i=>i)

                .Select(i => new {

                        Name = i.Key,

                        Total = i.Count()

                    })

                .OrderBy(i => i.Name)

                .ToList();

            foreach(var groupedOrderItem in groupedOrderItems){

                Console.WriteLine($"Order Item: {groupedOrderItem.Name} ({groupedOrderItem.Total})");

            }

        }

    }

}

​

public class Neighbourhood{

        public string Name {get;set;}

        public int Id {get;set;}

        public List<Order> Orders;

​

        public Neighbourhood(){

            Orders = new List<Order>();

        }

    }

​

public class Order{

    public int Id {get;set;}

    public List<string> OrderItems {get;set;}

    public Order(){

        OrderItems = new List<string>();

    }

}

​