CREATE TABLE table_name_11 (college_junior_club_team__league_ VARCHAR2, player VARCHAR2)

What is Brendan Locke's College/Junior/Club Team (League)?
SELECT college_junior_club_team__league_ FROM table_name_11 WHERE player = "brendan locke"
SELECT "college_junior_club_team__league_" FROM "table_name_11" WHERE "brendan locke" = "player"