CREATE TABLE table_name_40 (school_club_team VARCHAR2, player VARCHAR2)

What school/club team did Amal McCaskill play for?
SELECT school_club_team FROM table_name_40 WHERE player = "amal mccaskill"
SELECT "school_club_team" FROM "table_name_40" WHERE "amal mccaskill" = "player"