Sorting and Grouping
Organize query results with ORDER BY and GROUP BY.
Sorting and Grouping
ORDER BY sorts rows, while GROUP BY groups rows for summary results.
sql
SELECT department, COUNT(*) AS total_students
FROM students
GROUP BY department
ORDER BY total_students DESC;