Table: flanders_2008
Columns: number
name
kilometer
pavement
length_m
average_climb

Question: How many had a length of 455?
SQL: SELECT COUNT("name") FROM flanders_2008 WHERE "length_m" = 455

Question: What is the average climb for Tenbosse?
SQL: SELECT MIN("average_climb") FROM flanders_2008 WHERE "name" = 'Tenbosse'

Question: How many have a kilometers of 233?
SQL: SELECT "number" FROM flanders_2008 WHERE "kilometer" = 233

Question: How many have a length of 375?
SQL: SELECT COUNT("average_climb") FROM flanders_2008 WHERE "length_m" = 375