CREATE TABLE table_name_48 (player VARCHAR, school_club_team_country VARCHAR)

Who is the player for St. Mary's team?
SELECT player FROM table_name_48 WHERE school_club_team_country = "st. mary's"
SELECT "player" FROM "table_name_48" WHERE "school_club_team_country" = "st. mary's"