MySQL GROUP BY带条件统计

参数说明

count带参数

类如统计年龄大于多少时：语法：
1、select count( age > 23 or null) from asd
2、select count(if(age > 22, 1, null)) from asd
3、select count(case when age > 23 then 1 end) from asd
count()函数实现条件统计的原理是对于值为NULL的记录不计数，可以在条件中

select 
		 lci.id                        as ID,
       lct.template_name             as TEMPLATE_NAME, 
       lct.contract_type_name        as CONTRACT_TYPE_NAME,
       CASE lct.template_type WHEN 'standardText' THEN '标准文本' WHEN 'exampleText' THEN '示范文本' else  lct.template_type end         as TEMPLATE_TYPE,
       lci.creation_time		   as CONTRACT_TIME,
			 count(*) as TEMPLATE_COUNT,
			 count((lci.contract_status  in ('draft','approvaling','reject')) or NULL) as USEPASSED 
from table_cli lci 
LEFT JOIN table_lct lct on lci.RELATED_TEMPLATE = lct.id 
WHERE lct.TEMPLATE_STATUS = 'valid'
AND lct.deleted=0 AND lct.deleted = 0 
GROUP BY lci.contract_type_code,lct.TEMPLATE_TYPE,lct.TEMPLATE_TYPE 
order by TEMPLATE_COUNT DESC