Question

Write a query to display the name, department name and marks of the top performer(s) in Software Engineering , ordered by department name in ascending order.

Answer 1

Answer:

select student name, department name, value from student s join department d  

on s. department id = d. department id join mark m on s. student id = s.student_id

join subject su on m. subject id = su subject id where subject name = 'Software Engineering'

and value= (select max(value) from mark m1 join subject su1 on m1. subject id = su1 subject id where subject name = 'Software Engineering')

order by 2 asc;

Explanation

It can help you all.