Today I want to note that SQL Server has following order of processing:
- Group by
- Order By
By looking on this order you may understand why in C# LINQ from goes first and not select. That is because C# is imperative language, while SQL is declarative.