Distinct Combined With Order By
Group By And The Select Clause
Group By And The Having Clause
Order By Combined With Table And Column Aliases
Nested Aggregates
Update Statements With Aggregates
