188. JOINs with ORDER BY

1SELECT s.name, c.course_name, s.marks
2FROM students s
3JOIN courses c ON s.course_id = c.id
4ORDER BY c.course_name, s.marks DESC;