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

how many intersecting roads are there in rocky view county ?
SELECT COUNT("intersecting road") FROM table_204_763 WHERE "county" = 'rocky view county'
SELECT COUNT("intersecting road") FROM "table_204_763" WHERE "county" = 'rocky view county'