Vidhi Sharma is using a table Employee. It has the following columns: 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.
