• 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