Table: beaver_creek_bridge
Columns: name
listed
location
county
type

Question: What type of Bridge is in Stanley?
SQL: SELECT "type" FROM beaver_creek_bridge WHERE "location" = 'stanley'

Question: What type of bridge is Colton's Crossing Bridge?
SQL: SELECT "type" FROM beaver_creek_bridge WHERE "name" = 'colton''s crossing bridge'

Question: What bridge is a pratt pony through truss tyoe bridge?
SQL: SELECT "name" FROM beaver_creek_bridge WHERE "type" = 'pratt pony through truss'

Question: What type of bridge is in Cooperstown?
SQL: SELECT "type" FROM beaver_creek_bridge WHERE "location" = 'cooperstown'

Question: What bridge is in Mcville?
SQL: SELECT "name" FROM beaver_creek_bridge WHERE "location" = 'mcville'