What is the average length in feet of the bridges?
select avg(length_feet) from bridge