Table: wind_farms_onshore
Columns: wind_farm
capacity_mw
country
state_province
notes

Question: What is the total capacity (MW) of the farm that is noted as being under construction?
SQL: SELECT COUNT("capacity_mw") FROM wind_farms_onshore WHERE "notes" = 'under construction'

Question: Which state is Tehachapi Pass Wind Farm located in?
SQL: SELECT "state_province" FROM wind_farms_onshore WHERE "wind_farm" = 'tehachapi pass wind farm'

Question: Which wind farm is in the USA and is noted as having multiple farms?
SQL: SELECT "wind_farm" FROM wind_farms_onshore WHERE "country" = 'usa' AND "notes" = 'multiple farms'

Question: What special notes are included for the windfarm with a capacity (MW) of 343?
SQL: SELECT "notes" FROM wind_farms_onshore WHERE "capacity_mw" = 343

Question: What is the total capacity (MW) of the windfarm located in the state/province of Gansu?
SQL: SELECT SUM("capacity_mw") FROM wind_farms_onshore WHERE "state_province" = 'gansu'