Write a query to find out the sum, average, lowest and highest marks of the students in Student table grouped by STREAM.

Q. Write a query to find out the sum, average, lowest and highest marks of the students in Student table grouped by STREAM.

Answer :-

Select sum ( Marks ), avg ( Marks ), min ( Marks ), max ( Marks ) from Student group by STREAM ;