CREATE TABLE table_203_475 (id NUMBER, "stage" NUMBER, "date" CLOB, "route" CLOB, "terrain" CLOB, "length" CLOB, "winner" CLOB)

how many routes have below 100 km total ?
SELECT COUNT("route") FROM table_203_475 WHERE "length" < 100
SELECT COUNT("route") FROM "table_203_475" WHERE "length" < 100