title: 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
body: <p>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.</p>
  
  <p>This is what I tried.</p>
  
  <pre><code>select s.student_name 
    from student s,mark m,subject su
    where s.student_id=m.student_id and su.subject_id=m.subject_id and max(m.value)in 
    (select value from mark where lower(su.subject_name)='software engineering')
     order by s.student_name;
  </code></pre>
  
  <p>I am not getting the proper result.<a href="https://i.stack.imgur.com/ZQvfq.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZQvfq.jpg" alt="This is the schema"></a></p>