Count, orderby and group in LINQ

Question

Given a set

Paris New York London New York Paris Paris

I'm trying to do a LINQ query that will return a grouping of the Paris, New York, and London with their respective counts.

I've been able to do a GroupBy that returns a group containing only the Paris/New York/London in each Grouping.

Sounds relatively simple, but I can't get it to work?

Edit: It's not a homework problem.

Answer 1

Use .Count() on the groupings.

Answer 2

CODE

String[] input = new [] { "Paris", "New York", "London",
                          "New York", "Paris", "Paris" };

var groups = input
    .GroupBy(city => city)
    .Select(group => new { City = group.Key, Count = group.Count() });

foreach(var group in groups)
{
    Console.WriteLine("{0} occurs {1} time(s).", group.City, group.Count);
}

OUTPUT

Paris occurs 3 time(s).
New York occurs 2 time(s).
London occurs 1 time(s).