Table: allegheny_ridge_wind_farm
Columns: name
turbines
capacity_mw
power_mw_hr_yr
location_county
year_operational
status

Question: What year was Fayette operational at 46?
SQL: SELECT MIN("year_operational") FROM allegheny_ridge_wind_farm WHERE "location_county" = 'Fayette' AND "capacity_mw" = '46'

Question: What farm has a capacity of 70 and is operational?
SQL: SELECT "name" FROM allegheny_ridge_wind_farm WHERE "capacity_mw" = '70' AND "status" = 'Operational'

Question: What locations are considered centre?
SQL: SELECT "power_mw_hr_yr" FROM allegheny_ridge_wind_farm WHERE "location_county" = 'Centre'

Question: What all capacities have turbines between 50-60?
SQL: SELECT "capacity_mw" FROM allegheny_ridge_wind_farm WHERE "turbines" = '50-60'

Question: What all turbines have a capacity of 30 and have a Somerset location?
SQL: SELECT "turbines" FROM allegheny_ridge_wind_farm WHERE "location_county" = 'Somerset' AND "capacity_mw" = '30'