Skip
Arish's avatar

152. Practice - MIN by Group

Exercise: Min Marks per Course

Find minimum marks in each course.

Solution

sql
1SELECT course, MIN(marks) AS min_marks
2FROM students
3GROUP BY course;