SELECT, WHERE, ORDER BY, GROUP BY, HAVING, JOINs (INNER/LEFT/RIGHT/OUTER), subqueries, CTEs (Common Table Expressions), string/date functions, and basic table design.