user: ### NOW ANSWER:
Question: What is the total capacity (MW) of the windfarm located in the state/province of Gansu?
Columns: ['Wind farm', 'Capacity (MW)', 'Country', 'State/Province', 'Notes']
Types: ['text', 'real', 'text', 'text', 'text']
Sample row: ['Altamont Pass Wind Farm', 576.0, 'USA', 'California', 'multiple farms']
SQL:

assistant: SELECT SUM("Capacity (MW)") FROM "Table" WHERE "State/Province" = 'Gansu';