【MySql】groupby分组分类型求和 SUM（）if（）组合，根据时间合并数据

SELECT
	sum(if(`STATUS`=0,`count` ,0)) AS successCount,
	sum(if(`STATUS`=1,`count` ,0)) AS failCount,
	sum(`count` )AS totalCount,
	`create_time` 
FROM
	`T_HISTORY` 
GROUP BY
	DATE( `create_time` ) 
ORDER BY
	create_time DESC 
	LIMIT 10;

--  STATUS'发送结果(0:成功，1:失败)',