rank name notability birthplace advocate
rank
name
notability
birthplace
advocate
number
list length
address
number text <c,text> address text
10 wayne gretzky hockey player, holder of numerous nhl records brantford, ontario deborah grey
how many canadians listed were born in scotland ?
WRB JJ NNPS VBN VBD-AUX VBN IN NNP .
3
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String
select count ( * ) from w where c4_address = 'scotland'
Keyword Keyword None None None Column Column Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c4_address c4_address