year league record finish manager playoffs notes
year
league
record
finish
manager
playoffs
notes
number
number number1 number2
first second first_number
list length
number text score rank(text) <f,text> text text
1947 sunset league 69-69 4th (t) thomas lloyd league champs channel cities moved to reno july 1
who was the previous manager of the california league before ray perry ?
WP VBD-AUX DT JJ NN IN DT NNP NN IN NNP NNP .
Leonard Noren
Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Keyword Keyword Keyword Keyword
select c5_list from w where c2 = 'california league' and c1_number < ( select c1_number from w where c5_list = 'ray perry' ) order by id desc limit 1
Column None None Column Column None None Literal Literal Column Literal Literal None
c5_list c1_number c5_list c1_number