Use aggregate functions such as COUNT to summarize data
Apply string and date/time functions to format and manipulate data
Write nested queries to solve multi-step problems
Utilize window functions for advanced analytics
Implement SEMI JOIN and other advanced join types
Control query output using SQL-92 features
