sql查询时,需要统计某个字段的值出现的次数,使用sum(字段=值)例:
SELECT
sum( w.star_level = 0) noStars,
sum( w.star_level = 1) oneStars,
sum( w.star_level = 2) twoStars,
sum( w.star_level = 3) threeStars,
sum( w.star_level = 4) fourStart,
sum( w.star_level = 5) fiveStart,
count(*) sum
FROM w
查询结果如下