1. Basic Selection & Filters
Writing clean SELECT column lists, filtering with WHERE, pattern matching with LIKE, range queries with BETWEEN, and handling missing data with IS NULL.
2. Sorting & Pagination
Ordering results using ORDER BY ... ASC/DESC, limiting outputs with LIMIT, and selecting unique values via DISTINCT.
3. Aggregation & Grouping
Computing totals and metrics with COUNT(*), SUM(), AVG(), MAX(), and MIN() grouped by dimensions via GROUP BY and filtered with HAVING.
4. Multi-Table Relational Joins
Connecting data across tables using INNER JOIN and LEFT JOIN, chaining 3+ tables together, and performing self-joins to resolve organizational hierarchies.
5. Subqueries & Nested Queries
Writing scalar subqueries, list subqueries with IN and NOT IN, existence checks with EXISTS, and correlated subqueries referencing parent rows.
6. Conditional Logic (CASE WHEN)
Categorizing data dynamically using CASE WHEN ... THEN ... ELSE ... END to create VIP tiers, health categories, or custom rankings directly in query projections.