CREATE TABLE table_name_24 (school VARCHAR, team_name VARCHAR)

Which school are the Red Devils from?
SELECT school FROM table_name_24 WHERE team_name = "red devils"
SELECT "school" FROM "table_name_24" WHERE "red devils" = "team_name"