CREATE TABLE table_64907 ("School" TEXT, "City" TEXT, "Team Name" TEXT, "County" TEXT, "Year Joined" TEXT, "Year Left" TEXT)

Which school are the Red Devils from?
SELECT "School" FROM table_64907 WHERE "Team Name" = 'red devils'
SELECT "School" FROM "table_64907" WHERE "Team Name" = 'red devils'