Skip
Arish's avatar

186. Practice - JOIN with Filter 1

Exercise: Filter After Join

Find Python course students over 12.

Solution

sql
1SELECT s.name, c.course_name
2FROM students s
3JOIN courses c ON s.course_id = c.id
4WHERE c.course_name = 'Python' AND s.age > 12;