‣
‣
‣
‣
‣
‣
‣
‣
‣
‣
‣
‣
‣
‣
Comparison operators
Aggregate function
GROUP BY
HAVING statement has to be written again.
CASE WHEN
DISTINCT
ALIAS table name - FROM benn.college_football_players players
WHERE clause inside join
UNION
CAST(colname as integer) will change the column data type
Date
String functions
Window functions
Performance tuning