49) Write a query to display the student names and the maximum mark scored by them in any subject. Give an alias to the maximum mark as 'MAX_MARK'. Sort the records based on the name in ascending order.


 

Comments