Which schools have more than 1 player?
select t2.school from player as t1 join school as t2 on t1.school_id = t2.school_id group by t1.school_id having count ( * ) > 1
Okay, and where are the locations of each school?
select t2.school, t2.location from player as t1 join school as t2 on t1.school_id = t2.school_id group by t1.school_id having count ( * ) > 1