# date opponent score win loss save attendance record
#
date
opponent
score
win
loss
save
attendance
record
number
number parsed year month day
raw home
first second first_number first_number1 first_number2 second_number
first second second_number second_number1 second_number2
first second second_number second_number1 second_number2
first second second_number
number
number number1 number2
number date text score(number) text(score) text(score) text(number) number score
136 september 1 @ cubs 5 - 4 (11) marquis (11-8) patton (0-2) dempster (24) 40606 61-75
who did the astros play after the reds ?
WP VBD-AUX DT NNS VBP IN DT NNS .
Braves
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword
select c3 from w where c1_number > ( select max ( c1_number ) from w where c3_raw = 'reds' ) order by c1_number limit 1
Column None None None Column Column None Literal None
c3_raw c3_raw c1_number