CREATE TABLE table_204_763 (id NUMBER, "county" CLOB, "km" NUMBER, "intersecting road" CLOB, "notes" CLOB, "coordinates" CLOB)

how many intersecting roads come after highway 9 ?
SELECT COUNT("intersecting road") FROM table_204_763 WHERE id > (SELECT id FROM table_204_763 WHERE "intersecting road" = 'hwy 9')
SELECT COUNT("intersecting road") FROM "table_204_763" WHERE "id" > (SELECT "id" FROM "table_204_763" WHERE "intersecting road" = 'hwy 9')