Table: magic_players_8
Columns: player
nationality
position
years_in_orlando
school_club_team

Question: Which Years in Orlando has a School/Club Team of texas tech?
SQL: SELECT "years_in_orlando" FROM magic_players_8 WHERE "school_club_team" = 'texas tech'

Question: Which Nationality has a Player of keith bogans, and a Years in Orlando of 2006–2009?
SQL: SELECT "nationality" FROM magic_players_8 WHERE "player" = 'keith bogans' AND "years_in_orlando" = '2006–2009'

Question: What is Pat Burke's Nationality?
SQL: SELECT "nationality" FROM magic_players_8 WHERE "player" = 'pat burke'

Question: Which School/Club Team has a Player of michael bradley?
SQL: SELECT "school_club_team" FROM magic_players_8 WHERE "player" = 'michael bradley'

Question: Which Years in Orlando has a School/Club Team of kentucky?
SQL: SELECT "years_in_orlando" FROM magic_players_8 WHERE "school_club_team" = 'kentucky'

Question: Which School/Club Team has a Player of jud buechler?
SQL: SELECT "school_club_team" FROM magic_players_8 WHERE "player" = 'jud buechler'