user: ### NOW ANSWER:
Question: What Gender has the area of Swannanoa?
Columns: ['Name', 'Years', 'Gender', 'Area', 'Authority', 'Decile']
Types: ['text', 'text', 'text', 'text', 'text', 'real']
Sample row: ['Ashgrove School', '1–8', 'Coed', 'Rangiora', 'State', 9.0]
SQL:

assistant: SELECT "Gender" FROM "Table" WHERE "Area" = 'Swannanoa';