Detailed explanation and options for the selected question.
GROUP BY groups rows with the same values in specified columns. ORDER BY sorts results, WHERE filters rows, and LIMIT restricts row count.