SELECT with COUNT()

Q:5
Display the number of students in each batch.


SQL> SELECT BRANCH, COUNT(*) FROM STUDENT GROUP BY BRANCH;

BRANCH                 COUNT(*)
-------------------- ----------
COMMERCE                      2
HUMANITIES                    2
SCIENCE                       2