Which school has North Carolina as its team name?
select t1.school from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where team_name = 'North Carolina'
What is its location?
select t1.location from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where team_name = 'North Carolina'
How about the school that has Clemson as its team name?
select t1.school from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where team_name = 'Clemson'
Please list its location and all games score.
select t2.all_games, t1.location from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where team_name = 'Clemson'