WITH tmp AS(
SELECT
    AGE_CODE, 
    TIME_CODE,
    CASE WHEN TIME_CODE=120 THEN TARGET_POP ELSE 0 END AS 'POP_UNDER5',
    CASE WHEN TIME_CODE=130 THEN TARGET_POP ELSE 0 END AS 'POP_56',
    CASE WHEN TIME_CODE=140 THEN TARGET_POP ELSE 0 END AS 'POP_67',
    CASE WHEN TIME_CODE=150 THEN TARGET_POP ELSE 0 END AS 'POP_78',
    CASE WHEN TIME_CODE=160 THEN TARGET_POP ELSE 0 END AS 'POP_89',
    CASE WHEN TIME_CODE=170 THEN TARGET_POP ELSE 0 END AS 'POP_OVER9',
    CASE WHEN TIME_CODE=180 THEN TARGET_POP ELSE 0 END AS 'POP_UN'
FROM 
    SLEEP_TIME_DTL
)

SELECT
    AGE_NAME AS '年齢階層',
    SUM(POP_UNDER5) AS '5時間未満',
    SUM(POP_56) AS '5時間以上6時間未満',
    SUM(POP_67) AS '6時間以上7時間未満',
    SUM(POP_78) AS '7時間以上8時間未満',
    SUM(POP_89) AS '8時間以上9時間未満',
    SUM(POP_OVER9) AS '9時間以上',
    SUM(POP_UN) AS '不詳'
FROM tmp
    INNER JOIN AGE_GRP AS AG ON tmp.AGE_CODE=AG.AGE_CODE
GROUP BY 
    AGE_NAME
ORDER BY
    tmp.AGE_CODE
;