sql创建一个临时表进行关联

SELECT '正常生活' NAME, 
(SELECT COUNT(1) FROM  t_dws_dt_yd_tianfu_healthy_communication
WHERE HEALTH_CHECK = '3')
VALUE FROM DUAL
UNION
SELECT '居住隔离' NAME, 
(SELECT COUNT(1) FROM  t_dws_dt_yd_tianfu_healthy_communication
WHERE HEALTH_CHECK = '1')
VALUE FROM DUAL
UNION
SELECT '集中隔离' NAME, 
(SELECT COUNT(1) FROM  t_dws_dt_yd_tianfu_healthy_communication
WHERE HEALTH_CHECK = '2')
VALUE FROM DUAL
UNION
SELECT '隔离治疗' NAME, 
(SELECT COUNT(1) FROM  t_dws_dt_yd_tianfu_healthy_communication
WHERE HEALTH_CHECK = '4')
VALUE FROM DUAL
UNION
SELECT '其他' NAME, 
(SELECT COUNT(1) FROM  t_dws_dt_yd_tianfu_healthy_communication
WHERE HEALTH_CHECK = '5')
VALUE FROM DUAL

SELECT B.NAME ,A.`value`FROM
        (SELECT  '正常生活' name FROM DUAL
        UNION 
        SELECT  '居住隔离' name FROM DUAL
        UNION 
        SELECT  '集中隔离' name FROM DUAL
        UNION
        SELECT  '隔离治疗' name FROM DUAL
        UNION 
        SELECT  '其他' name FROM DUAL)
        B
LEFT JOIN
(SELECT
        CASE
        WHEN HEALTH_CHECK = '1' THEN '居住隔离'
        WHEN HEALTH_CHECK = '2' THEN '集中隔离'
        WHEN HEALTH_CHECK = '3' THEN '正常生活'
        WHEN HEALTH_CHECK = '4' THEN '隔离治疗'
        ELSE '其他'
        END as name,
         count(1) value
        FROM
         t_dws_dt_yd_tianfu_healthy_communication
        GROUP BY name) A
                ON A.`name`= B.`name`