user: ### NOW ANSWER:
Question: Where was the county of Rockingham?
Columns: ['Name', 'County', 'Location', 'Built', 'Length (ft)', 'Spans']
Types: ['text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Biedler Farm', 'Rockingham', 'Broadway', '1896', 93.0, 'Smith Creek']
SQL:

assistant: SELECT "Location" FROM "Table" WHERE "County" = 'Rockingham';