CREATE TABLE table_name_54 (school VARCHAR, team_name VARCHAR)

What school had a team name of the Trojans?
SELECT school FROM table_name_54 WHERE team_name = "trojans"
SELECT "school" FROM "table_name_54" WHERE "team_name" = "trojans"