Skip
Arish's avatar

187. Practice - JOIN with Filter 2

Exercise: Multiple Conditions

Find grade A students in programming courses.

Solution

sql
1SELECT s.name, s.grade, c.course_name
2FROM students s
3JOIN courses c ON s.course_id = c.id
4WHERE s.grade = 'A'
5AND c.category = 'Programming';