select count(extension_num) as callAll,sum(talk_length) as talkLength,
count(case when call_type=1 then 1 else null end) as callin,
count(case when call_type=0 then 1 else null end) as callout,
COUNT(case when call_type=0 and talk_length>0 then 1 else null end) as calloutYes,
COUNT(case when call_type=0 and talk_length=0 then 1 else null end) as calloutNo,
COUNT(case when call_type=1 and talk_length=0 then 1 else null end) as callinNo,
COUNT(case when call_type=1 and talk_length>0 then 1 else null end) as callInYes,
extension_num from t_call_call_record GROUP BY extension_num;多条件
select count(id) totalCnt,COUNT(case when warehouse_type=0 then null else 1 end) fixedCnt,
COUNT(case WHEN warehouse_type=1 then 1
WHEN warehouse_type=2 then 1
when warehouse_type=0 and use_status=1 then 1
else null end) usedCnt
from storage_warehouse where `status`=0 and delete_status=0;