【mysql】mysql case when实现不同条件查询

代码示例

SELECT 
SUM(CASE WHEN e.cost_audit_type = 1 AND date_format(e.cost_audit_time, '%Y-%m') = '2016-11' 
THEN e.cost_money ELSE 0 END),

SUM(CASE WHEN e.payment_audit_type = 1  AND date_format(e.payment_audit_time, '%Y-%m') = '2016-11' 
THEN e.total_amount ELSE 0 END)

FROM tb_proj t, tb_proj_execut_sheet e, sys_user s

WHERE t.id = e.proj_id AND t.proj_manage_eid = s.ID AND t.proj_manage_eid = c.eid GROUP BY t.id