CREATE TABLE table_name_35 (school_club_team VARCHAR, player VARCHAR)

What school does John Crotty play for?
SELECT school_club_team FROM table_name_35 WHERE player = "john crotty"
SELECT "school_club_team" FROM "table_name_35" WHERE "john crotty" = "player"