Question

Write a query to display list student id and the minimum mark scored by that students in any subject.Give an alias as minimum_mark. Sort the result based on minimum_mark

Answer 1

Select

 stud.studentId,  

 sub.subjectname,

 min(m.value)

from subject sub

inner join mark m

on m.subjectid = sub.subjectid

order by mark

Explanation:

• This query displays  the studentId from the table student, subject name and minimum mark obtained from the table subject.
• And this query has a joint condition with the studentid attribute from the tables marks and subject.
• This query is sorted based on the mark of the student from the table mark.

To Learn more;

1. https://brainly.in/question/11828491

2. https://brainly.in/question/11828499