CREATE TABLE table_name_34 (school_club_team VARCHAR, player VARCHAR)

Which School/Club Team did Andre Wakefield play for?
SELECT school_club_team FROM table_name_34 WHERE player = "andre wakefield"
SELECT "school_club_team" FROM "table_name_34" WHERE "andre wakefield" = "player"