gistfile1.txt

select sportgroups.id as sportgroupId, sports.name as sport, sportgroups.location as location
from sports join sportgroups
on sports.id in (
	select sport_id
    from sportgroups
    where sportgroups.location like '%Sofia%'
);