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:6
Display the highest and lowest mark in COMMERCE batch.
SQL> SELECT MIN(TOTAL), MAX(TOTAL) FROM STUDENT WHERE BRANCH='COMMERCE';
MIN(TOTAL) MAX(TOTAL)
---------- ----------
300 400