it's not SQL. it's LINQ to query a datatable, with grouping