Question

Shanya Khanna is using a table EMPLOYEE. It has the following columns: (1)
Admno, Name, Agg, Stream [column Agg contains Aggregate marks]
She wants to display highest Agg obtained in each Stream. She wrote the following statement:
SELECT Stream, MAX (Agg) FROM EMPLOYEE;
But she did not get the desired result. Rewrite the above query with necessary
changes to help her get the desired output.

Answer 1

ANSWER

SELECT Stream, MAX(AggMark) FROM Employee GROUP BY Stream;