多条件sql语句怎么变成一条sql语句

Question

像这样的
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

Answer 1

用分组查询或者union