home team score away team date agg
home team
score
away team
date
agg
number number1 number2
number parsed year month day
number number1 number2
text score text date score
aberdeen 7-1 hamilton academical 11-10-1978 8-1
what home team is above clydebank ?
WDT NN NN VBD-AUX IN NNP .
Ayr United
Keyword Column Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword
select c1 from w where id = ( select id from w where c1 = 'clydebank' ) - 1
None Column Column None Keyword Literal None
c1 c1 ['before', 'before_minus']