case when

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');