Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT coaches.name,
- sports.name
- FROM coaches JOIN sports
- ON coaches.id IN ( SELECT coach_id
- FROM sportgroups
- WHERE sportgroups.id IN ( SELECT sportGroup_id
- FROM student_sport JOIN students
- WHERE student_id = students.id
- AND students.name = 'Iliyan Ivanov') )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement