Table: colorado_ski_resorts
Columns: name
nearest_city
skiable_area_acres
top_elevation_feet
base_elevation_feet
vertical_feet
runs
lifts
snowfall_in_year

Question: If there are 11 lifts, what is the base elevation?
SQL: SELECT MAX("base_elevation_feet") FROM colorado_ski_resorts WHERE "lifts" = 11

Question: if there are 30 lifts, what is the name of the ski resort?
SQL: SELECT "name" FROM colorado_ski_resorts WHERE "lifts" = 30

Question: If the name is Steamboat, what is the top elevation?
SQL: SELECT "top_elevation_feet" FROM colorado_ski_resorts WHERE "name" = 'Steamboat'

Question: How many resorts have 118 runs?
SQL: SELECT COUNT("name") FROM colorado_ski_resorts WHERE "runs" = '118'

Question: What is the snowfall for ski resort Snowmass?
SQL: SELECT MAX("snowfall_in_year") FROM colorado_ski_resorts WHERE "name" = 'Snowmass'