Table: flanders_climb
Columns: number
name
kilometer
pavement
length_m
average_climb

Question: What is the Length (m) of the Koppenberg course?
SQL: SELECT "length_m" FROM flanders_climb WHERE "name" = 'koppenberg'

Question: What is the Kilometer of the Berendries asphalt course with an Average climb less than 7 and Length (m) longer than 645?
SQL: SELECT AVG("kilometer") FROM flanders_climb WHERE "pavement" = 'asphalt' AND "length_m" > 645 AND "name" = 'berendries' AND "average_climb" < 7

Question: What is the Number of the Koppenberg course with less than 195 Kilometers?
SQL: SELECT COUNT("number") FROM flanders_climb WHERE "name" = 'koppenberg' AND "kilometer" < 195