WHERE → rows

GROUP BY column[, …]:

HAVING → groups (take action after GROUP BY)

ORDER BY !can only used for the outer SELECT (cannot for the nested)