release date single title uk singles chart
position french
charts german
charts irish
charts various
release date
single title
uk singles chart position
french charts
german charts
irish charts
various
number parsed year month
number
number
number
number
list length list_first list_second list_first_number
date text number number number number <c,rank(text)>
may 1976 "sister mary" (duet with joe dolan) 1 5 5 2 #22 (netherlands), #5 (south africa)
how many single titles were on both the irish and german charts ?
WRB JJ JJ NNS VBD-AUX IN CC DT JJ CC JJ NNS .
3
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Keyword Keyword Column Keyword Keyword
select count ( c2 ) from w where c6 not null and c5 not null
Keyword Keyword Column Column None Keyword Keyword None Column Keyword Column Column None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c2 ['null', 'null_not'] ['conj', 'conj_and'] c6 ['conj', 'conj_and'] c5 c5