select st.name,st.egn,sports.name
from students as st
join sports
on st.id	in(
					select student_sport.student_id
                    from student_sport
                    where student_sport.sportGroup_id in( select sportgroups.sport_id
														from sportgroups
                                                        where sportgroups.sport_id = sports.id));