Table schema:
CREATE TABLE table_name_24 (school VARCHAR, team_name VARCHAR)

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