Table: covered_bridges_virginia
Columns: name
county
location
built
length_ft
spans

Question: What spans were built in 1896?
SQL: SELECT "spans" FROM covered_bridges_virginia WHERE "built" = '1896'

Question: Who has a length of 71 ft?
SQL: SELECT "name" FROM covered_bridges_virginia WHERE "length_ft" = 71

Question: Where was the county of rockingham?
SQL: SELECT "location" FROM covered_bridges_virginia WHERE "county" = 'rockingham'