Table: florida_historic_bridges
Columns: name
built
listed
location
county
type

Question: What is the listed date of the Warren pony truss bridge that was built in 1925?
SQL: SELECT "listed" FROM florida_historic_bridges WHERE "built" = '1925' AND "type" = 'warren pony truss'

Question: When was Moores Creek Bridge built?
SQL: SELECT "built" FROM florida_historic_bridges WHERE "name" = 'moores creek bridge'

Question: When was Blackburn Point Bridge built?
SQL: SELECT "built" FROM florida_historic_bridges WHERE "name" = 'blackburn point bridge'

Question: What county is the St. Augustine bridge in?
SQL: SELECT "county" FROM florida_historic_bridges WHERE "location" = 'st. augustine'