Detailed explanation and options for the selected question.
ORDER BY sorts query results in ascending or descending order. WHERE filters rows, GROUP BY groups rows, and LIMIT restricts row count.