SELECT with MIN() and MAX()

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