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 songs charted at least 50th or better on the uk singles chart ?
WRB JJ NNS VBD IN JJS JJ CC RBR IN DT NNP NNS NN .
3
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c3_number <= 50
Keyword Keyword Column None Keyword Keyword Literal Keyword Keyword None None Column Column Column None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 ['comp', 'comp_lequal'] ['comp', 'comp_lequal'] ['comp', 'comp_lequal'] ['comp', 'comp_lequal'] c3_number c3_number c3_number