1) Basic Select Operations
2) Joins
3) Set Operators (Union, Union all, Minus, Intersect)
4) Conditional Functions Decode, NVL, Case etc