COUNT() with GROUP BY and ORDER BY

Q:15
Display the total number of students in each batch in the descending order of total number.


SQL>  SELECT BRANCH, COUNT(*) "Number" FROM STUDENT GROUP BY BRANCH ORDER BY 2 DESC;

BRANCH                   Number
-------------------- ----------
SCIENCE                       3
HUMANITIES                    2
COMMERCE                      1