rank name caps goals years
rank
name
caps
goals
years
number
number
number
minimum_number minimum_parsed minimum_year maximum_number maximum_parsed maximum_year
number text number number timespan
1 bedford jezzard 3 6 1954-1955
which name is listed after alan smith ?
WDT NN VBD-AUX VBN IN NNP NNP .
Jack Rowley
select c2 from w where id = ( select id from w where c2 = 'alan smith' ) + 1