What is the length in feet of each bridge?
select length_feet from bridge
Find the average length.
select avg(length_meters) from bridge