- UNION - DISTINCT - HAVING - LEFT / RIGHT JOINs - Sub-queries - GROUP BY - Aggregate Functions
Pro tip: use ```triple backticks around text``` to write in code fences