CREATE TABLE table_name_9 (area VARCHAR, years VARCHAR, name VARCHAR)

Which area has Years of 1 8, and a Name of broomfield school?
SELECT area FROM table_name_9 WHERE years = "1–8" AND name = "broomfield school"
SELECT "area" FROM "table_name_9" WHERE "1–8" = "years" AND "broomfield school" = "name"