What is the average length in feet of the bridges?
CREATE TABLE bridge (length_feet INTEGER)
SELECT AVG(length_feet) FROM bridge
### Context: CREATE TABLE bridge (length_feet INTEGER) ### Question: What is the average length in feet of the bridges? ### Answer: SELECT AVG(length_feet) FROM bridge