Subquery - CTE - DateDiff
Union - Self Join - Constraint
Join - Union
Like - Aggreagate Functions - Group By - Inner Join - Left Outer Join - Cross Join
Distinct - CAST - CONVERT - Built in Functions ,