Table 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