rank name height
ft (m) floors year coordinates notes
rank
name
height ft -lrb- m -rrb-
floors
year
coordinates
notes
number
first second first_number second_number
number
minimum_number minimum_parsed minimum_year maximum_number maximum_parsed maximum_year
number text number(number) number timespan text text
1 ordway building 404 (123) 28 1970 37°48′36′′n 122°15′51′′w﻿ / ﻿37.81000°n 122.26417°w tallest building in both oakland and in the bay area outside of san francisco; tallest building constructed in the 1970s
how many of the tallest buildings in oakland were built before 1950 ?
WRB JJ IN DT JJS NNS IN NNP VBD-AUX VBN IN CD .
5
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c5_minimum_number < 1950
Keyword Keyword None None None Column None None None None Column Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c5_minimum_number