user: Question: Which area has Years of 1–8, and a Name of Broomfield School?
Columns: ['Name', 'Years', 'Gender', 'Area', 'Authority', 'Decile', 'Roll']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'real']
Sample row: ['Amberley School', '1–8', 'Coed', 'Amberley', 'State', 7.0, 230.0]
SQL:

assistant: SELECT "Area" FROM "Table" WHERE "Years" = '1–8' AND "Name" = 'Broomfield School';