casewhen`manager`
select date_format(create_time,'%m-%d') as days, sum(case when (content_type=4 and reply_content_type= -5 )then 1 else 0 end) 'islan',sum(case reply_content_type when -7 then 1 else 0 end) 'welcome',
sum(case when reply_content_type=-1 then 1 else 0 end) 'jitang'
from robotapi.messenger_record where date(create_time) >='2018-07-23' and date(create_time)<='2018-07-25' group by date_format(create_time,'%Y%m%d');
select date_format(create_time,'%m-%d') as days,
sum(case when (content_type=4 and reply_content_type= -5 )then 1 else 0 end) 'islan',
sum(case reply_content_type when -7 then 1 else 0 end) 'welcome',
sum(case when reply_content_type=-1 then 1 else 0 end) 'jitang'
from robotapi.messenger_record where date(create_time) >='2018-07-23' and date(create_time)<='2018-07-25'
group by date_format(create_time,'%Y%m%d');