Write a query to find the name of the student(s) who has scored maximum mark in Software Engineering. Sort the result based on name.
USING: join & subquery
Answers
Answered by
2
Answer:
select student_name ,department_name,value from student
inner join department using(department_Id)
inner join mark using(student_Id)
inner join subject using (subject_Id)
where value=(select max(value) from mark join subject using (subject_Id)
where lower(subject_name)='software engineering')
and lower(subject_name)='software engineering'
order by department_name;
Explanation:
Similar questions