year single charts
fr charts
bel
wa charts
swi certification album
year
single
charts fr
charts bel wa
charts swi
certification
album
number
number
number
number
number text number number number number text
1997 "sur la route" 14 4 73 la derniere annee
how many singles were released before 2001 but after 1997 ?
WRB JJ NNS VBD-AUX VBN IN CD CC IN CD .
1
Keyword Keyword Keyword Column Keyword Keyword Keyword Keyword Column Keyword Literal.Number Keyword Column Keyword Literal.Number
select count ( c2 ) from w where c1_number < 2001 and c1_number > 1997
Keyword Keyword Column None None Column Literal None Column Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] c2 c1_number c1_number