SELECT ES_Eval_Result AS Result,
(SELECT num
FROM (SELECT ES_Eval_Result, COUNT(ES_ID) AS num, ES_Stage
FROM ES_EvaluateStandard
WHERE (VP_ID = 28)
GROUP BY ES_Stage, ES_Eval_Result) AS es1
WHERE (ES_Eval_Result = es2.ES_Eval_Result) AND (ES_Stage = 0)) AS 概念策划阶段
FROM (SELECT DISTINCT ES_Eval_Result
FROM (SELECT ES_Eval_Result, COUNT(ES_ID) AS num, ES_Stage
FROM ES_EvaluateStandard AS ES_EvaluateStandard_1
WHERE (VP_ID = 28)
GROUP BY ES_Stage, ES_Eval_Result) AS es1_1) AS es2
当列“概念策划阶段”为null时转化为0