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