# stadium capacity city home team
#
stadium
capacity
city
home team
number
number
number text number text text
1 windsor park 24734 belfast linfield, northern ireland national team
how many stadiums have a capacity between 6000 and 8000 ?
WRB JJ NNS VBD-AUX DT NN IN CD CC CD .
10
select count ( c2 ) from w where c3_number >= 6000 and c3_number <= 8000