name nation position league apps league goals fa cup apps fa cup goals total apps total goals
name
nation
position
league apps
league goals
fa cup apps
fa cup goals
total apps
total goals
number
number
number
number
number
number
text text text number number number number number number
ned barkas england df 4 0 0 0 4 0
average number of goals scored by players from scotland
JJ NN IN NNS VBN IN NNS IN NNP
1
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.String
select avg ( c9_number ) from w where c2 = 'scotland'
Keyword Keyword Keyword Column None None None Column Literal
['agg', 'agg_avg'] ['agg', 'agg_avg'] ['agg', 'agg_avg'] c9_number c2