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
indicate how many of the buildings in oakland which stand at least 200 ft tall have more than 20 floors .
VB WRB JJ IN DT NNS IN NNP WDT VBP IN JJS CD NNP JJ VBD-AUX JJR IN CD NNS .
12
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c3_first_number >= 200 and c4_number > 20
None Keyword Keyword None None Column None None None None Keyword Keyword Literal Column Column None Keyword Keyword Literal Column None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 ['comp', 'comp_gequal'] ['comp', 'comp_gequal'] c3_first_number c3_first_number ['comp', 'comp_greater'] ['comp', 'comp_greater'] c4_number