SELECT и FROM

ORDER BY

WHERE и AND

DISTINCT

COUNT и GROUP BY

AVG по группам

MAX по группам

HAVING

CASE WHEN

LEFT JOIN