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

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'