year single us cashbox us hot 100 uk singles
year
single
us cashbox
us hot 100
uk singles
number
number
number
number
number text number number number
1969 "rock & roll holiday" 85 96 52
how many songs charted on both the us cashbox and us hot 100 but not the uk singles ?
WRB JJ NNS VBD IN CC DT NNP NNP CC PRP JJ CD CC RB DT NNP NNS .
5
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword
select count ( c2 ) from w where c3 not null and c4 not null and c5 is null
Keyword Keyword Column Keyword None None None Column Column None Column Column Column None Keyword None Column Column None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 ['null', 'null_not'] c3 c3 c4 c4 c4 ['null', 'null_null'] c5 c5