像这样的
select count(price) from jdplaying where price<=100
select count(price) from jdplaying where price >100 and price <=500
select count(price) from jdplaying where price >500 and price <=1000
select count(price) from jdplaying WHERE price >1000 and price <=1500
select count(price) from jdplaying where price >1500
用分组查询或者union