CREATE TABLE table_67632 ("Name" CLOB, "Years" CLOB, "Gender" CLOB, "Area" CLOB, "Authority" CLOB, "Decile" FLOAT, "Roll" FLOAT)

Which area has Years of 1 8, and a Name of broomfield school?
SELECT "Area" FROM table_67632 WHERE "Years" = '1–8' AND "Name" = 'broomfield school'
SELECT "Area" FROM "table_67632" WHERE "Name" = 'broomfield school' AND "Years" = '1–8'