Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2
Q:11
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 2
HUMANITIES 2
SCIENCE 2