Step 1: Select rows where 'location' is 'rockland'.
county |
location |
street_names |
milepost |
roads_intersected |
notes |
norfolk |
stoughton |
pleasant street turnpike street lindelof avenue |
3.0 |
route 24 |
route 24 exit 20 |
norfolk |
weymouth |
anne street |
(no major junctions) |
(no major junctions) |
(no major junctions) |
plymouth |
rockland |
north avenue plain street market street |
12.2 |
route 123 |
western terminus of route 123 / 139 concurrency |
plymouth |
rockland |
north avenue plain street market street |
12.8 |
route 123 |
eastern terminus of route 123 / 139 concurrency |
plymouth |
hanover |
hanover street rockland street columbia road |
17.9 |
route 53 |
northern terminus of route 53 / 139 concurrency |
Step 2: Select rows where 'milepost' is 12.8.
county |
location |
street_names |
milepost |
roads_intersected |
notes |
plymouth |
rockland |
north avenue plain street market street |
12.2 |
route 123 |
western terminus of route 123 / 139 concurrency |
plymouth |
rockland |
north avenue plain street market street |
12.8 |
route 123 |
eastern terminus of route 123 / 139 concurrency |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
county |
location |
street_names |
milepost |
roads_intersected |
notes |
plymouth |
rockland |
north avenue plain street market street |
12.8 |
route 123 |
eastern terminus of route 123 / 139 concurrency |
Prediction: TRUE
Ground-truth: TRUE