SELECT USING COUNT() with GROUP BY

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


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

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