Computer Science, asked by Nithyagokulapriya, 2 months ago

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 SwagnikChakraborty
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