Table: mountain_climbs_2
Columns: height_m
no_of_times_visited
no_of_hc_climbs
first_time_as_hc_climb
most_recent

Question: When was the first HC climb which, more recently than 2012, had more than 1 HC climbs, more than 29 times visited?
SQL: SELECT SUM("first_time_as_hc_climb") FROM mountain_climbs_2 WHERE "no_of_hc_climbs" > 1 AND "no_of_times_visited" > 29 AND "most_recent" > 2012

Question: How many HC climbs had 1 visit more recently than 1984, a first HC climb before 1994, and a height of 1900?
SQL: SELECT "no_of_hc_climbs" FROM mountain_climbs_2 WHERE "no_of_times_visited" = 1 AND "most_recent" > 1984 AND "first_time_as_hc_climb" < 1994 AND "height_m" = '1900'

Question: What is the height with more than 2 HC climbs more recent than 2012, less than 48 times visited, and a first HC climb in 1989?
SQL: SELECT "height_m" FROM mountain_climbs_2 WHERE "no_of_hc_climbs" > 2 AND "most_recent" = 2012 AND "no_of_times_visited" < 48 AND "first_time_as_hc_climb" = 1989

Question: What was the most recent year a height of 2770 m and a HC climb before 1992 was climbed?
SQL: SELECT COUNT("most_recent") FROM mountain_climbs_2 WHERE "height_m" = '2770' AND "first_time_as_hc_climb" < 1992

Question: When was the first HC climb before 2013 with more than 3 times visited, more than 4 HC climbs, and a height of 1669?
SQL: SELECT "first_time_as_hc_climb" FROM mountain_climbs_2 WHERE "no_of_times_visited" > 3 AND "no_of_hc_climbs" = 4 AND "most_recent" < 2013 AND "height_m" = '1669'