bridge name location year completed total length carries
bridge name
location
year completed
total length
carries
address
number
first second first_number second_number
text address number unitnum(unitnum) text
old youngs bay bridge astoria, oregon 1921 1,766.2 feet (538.3 m) u.s. route 101
how many bridges are 400 feet long at most ?
WRB JJ NNS VBD-AUX CD NNS RB IN JJS .
6
select count ( c1 ) from w where c4_first_number <= 400