https://developerpublish.com/how-to-get-the-max-row-with-group-by-in-linq-query-using-c/
How to get the MAX row with group by in LINQ query using C# ?