year player position high school college
year
player
position
high school
college
number
list length
number text <d, text> text text
1987 buster howe rb-db-k-p zanesville ohio state
who was the player of the year before robert smith ?
WP VBD-AUX DT NN IN DT NN IN NNP NNP .
Buster Howe
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword
select c2 from w where c1_number = ( select c1_number from w where c2 = 'robert smith' ) - 1
Column None None Column None None Column Keyword Literal Literal None
c2 c2 c1_number ['before', 'before_minus']