Table: magic_roster_6
Columns: player
nationality
position
years_in_orlando
school_club_team

Question: What year did Orlando have a School/Club team in Clemson?
SQL: SELECT "years_in_orlando" FROM magic_roster_6 WHERE "school_club_team" = 'clemson'

Question: What years did the player in Orlando play that is from the United States, and is part of the school/club team Clemson?
SQL: SELECT "years_in_orlando" FROM magic_roster_6 WHERE "nationality" = 'united states' AND "school_club_team" = 'clemson'

Question: Who is the player for the School/Club team in Georgia?
SQL: SELECT "player" FROM magic_roster_6 WHERE "school_club_team" = 'georgia'

Question: What was the nationality of the player Pat Garrity?
SQL: SELECT "nationality" FROM magic_roster_6 WHERE "player" = 'pat garrity'

Question: What is the nationality of the School/Club team of Louisville?
SQL: SELECT "nationality" FROM magic_roster_6 WHERE "school_club_team" = 'louisville'