Detailed explanation and options for the selected question.
HAVING filters grouped rows. WHERE filters rows before grouping, ORDER BY orders rows, and JOIN links tables.