Table: canada_generating_stations
Columns: rank
name
capacity_mw
province
type

Question: what is the least capacity (mw) when the rank is less than 46 and the province is newfoundland and labrador?
SQL: SELECT MIN("capacity_mw") FROM canada_generating_stations WHERE "rank" < 46 AND "province" = 'newfoundland and labrador'

Question: what is the lowest rank when the type is hydro, the name is grand rapids generating station and the capacity (mw) is more than 479?
SQL: SELECT MIN("rank") FROM canada_generating_stations WHERE "type" = 'hydro' AND "name" = 'grand rapids generating station' AND "capacity_mw" > 479

Question: what is the province when the rank is higher than 24 and the name is laforge-2?
SQL: SELECT "province" FROM canada_generating_stations WHERE "rank" > 24 AND "name" = 'laforge-2'

Question: what is the name when the type is hydro, the capacity (mw) is less than 478, the rank is more than 85 and the province is quebec?
SQL: SELECT "name" FROM canada_generating_stations WHERE "type" = 'hydro' AND "capacity_mw" < 478 AND "rank" > 85 AND "province" = 'quebec'