sql 统计 sum case when 配合使用

统计个数

'SELECT  count(*) as total,
SUM(CASE WHEN `register_time` >= "'.$data['today'].'" THEN 1 ELSE 0 END) as today,
SUM(CASE WHEN `register_time` >= "'.$data['yesterday'].'" AND `register_time` < "'.$data['today'].'" THEN 1 ELSE 0 END) as yesterday,
SUM(CASE WHEN `register_time` >= "'.$data['month'].'" THEN 1 ELSE 0 END) as month
FROM `sys_login_user`';

统计字段总和

select SUM(case organic_state when 'Non-organic' then amount else 0 end) as amount1, SUM(case organic_state when 'Organic' then amount else 0 end) as amount2 from pay_record where dd_ts=20220215 GROUP BY channel_id

当organic_state字段 值 等于Non-organic统计钱是多少

当organic_state字段 值 等于Organic 统计钱是多少