Table: ski_jumping_world_cup_18
Columns: rank
name
nationality
1st_m
2nd_m
points
overall_nt_points
overall_wc_points_rank

Question: Which name has a distance for 1st as 117.5?
SQL: SELECT "name" FROM ski_jumping_world_cup_18 WHERE "1st_m" = 117.5

Question: What is the distance for Tom Hilde for 2nd when the 1st distance is more than 117.5?
SQL: SELECT "2nd_m" FROM ski_jumping_world_cup_18 WHERE "1st_m" > 117.5 AND "name" = 'tom hilde'

Question: What are the most points for Thomas Morgenstern with a distance less than 123.5 in 2nd and rank over 4?
SQL: SELECT MAX("points") FROM ski_jumping_world_cup_18 WHERE "2nd_m" < 123.5 AND "name" = 'thomas morgenstern' AND "rank" > 4

Question: What is the sum of the distances in 2nd for ranks higher than 4 and distance for 1st less than 111.5?
SQL: SELECT SUM("2nd_m") FROM ski_jumping_world_cup_18 WHERE "rank" > 4 AND "1st_m" < 111.5

Question: Who had more than 247.1 points and less than 125 meter distance for 1st?
SQL: SELECT "name" FROM ski_jumping_world_cup_18 WHERE "points" > 247.1 AND "1st_m" < 125