Table: road_intersections
Columns: county
location
street_names
milepost
roads_intersected
notes

Question: How many mileposts are there on Anne Street?
SQL: SELECT COUNT("milepost") FROM road_intersections WHERE "street_names" = 'Anne Street'

Question: Which street is 12.2 miles long?
SQL: SELECT "street_names" FROM road_intersections WHERE "milepost" = '12.2'

Question: Where does Route 24 intersect?
SQL: SELECT "location" FROM road_intersections WHERE "roads_intersected" = 'Route 24'

Question: Where is milepost 12.8?
SQL: SELECT "location" FROM road_intersections WHERE "milepost" = '12.8'