The SQL commands of T-SQL have to be used in a specified order.
4 Group By
7 Order By
Saw somewhere a nice mnemonic for this:
Sweaty Feet Will Give Horrible Odours
Because I tend to forget these order and this mnemonic is still not strong enough I'm thinking about another one: