mysql - 查询数量与比例 case when then...

技术

 0  532

小学生举报

2023-08-18

```

SELECT

SUM(CASE WHEN reward_redpack_num < 0.31 THEN 1 ELSE 0 END) AS '0.01-0.3区间',

ROUND(SUM(CASE WHEN reward_redpack_num < 0.31 THEN 1 ELSE 0 END) /COUNT(*),2) AS '0.01-0.3区间占比',

SUM(CASE WHEN reward_redpack_num >= 1 AND reward_redpack_num < 2 THEN 1 ELSE 0 END) AS '1-2区间',

ROUND(SUM(CASE WHEN reward_redpack_num >= 1 AND reward_redpack_num < 2 THEN 1 ELSE 0 END) /COUNT(*),2) AS '1-2区间占比',

SUM(CASE WHEN reward_redpack_num >= 2 AND reward_redpack_num < 3 THEN 1 ELSE 0 END) AS '2-3区间',

ROUND(SUM(CASE WHEN reward_redpack_num >= 2 AND reward_redpack_num < 3 THEN 1 ELSE 0 END) /COUNT(*),2) AS '2-3区间占比'

FROM `sskp_sign_in_list` WHERE query_type = 11AND add_time> UNIX_TIMESTAMP('2023-08-18 10:30:00') ORDER BY id DESC LIMIT 1000

```

倒序看帖只看楼主

回帖