1. 计算某天各个业务渠道注册的用户量
select DATE_FORMAT(insert_time, '%Y-%m-%d'),
count(case when business_channel = '00' then id end) as 'APP',
count(case when business_channel = '01' then id end) as '小程序',
count(case when business_channel = '02' then id end) as 'H5'
from mall_user
group by DATE_FORMAT(insert_time, '%Y-%m-%d')
运行结果如下: