Detailed explanation and options for the selected question.
HAVING filters rows after grouping. WHERE filters rows before grouping, GROUP BY groups rows, and LIMIT restricts row count.