what location are the clemson teams?
select t1.location from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where team_name = 'Clemson'
what scores were Clemson's home games?
select t2.all_home from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where team_name = 'Clemson'
How about the road game scores for Clemson?
select t2.all_road from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where team_name = 'Clemson'
What about all games score for the Clemson school?
select t2.all_games from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where team_name = 'Clemson'
How about for the Duke school?
select t2.all_games from university as t1 join basketball_match as t2 on t1.school_id = t2.school_id where team_name = 'Duke'