WITH prep AS(
    SELECT
        TIME_CODE,
        AGE_CODE,
        SUM(TARGET_POP) AS TARGET_POP
    FROM
        SLEEP_TIME_DTL
    GROUP BY
        TIME_CODE,
        AGE_CODE
)
SELECT
    ag.AGE_NAME AS '年齢階層',
    MAX(CASE WHEN pr.TIME_CODE = 120 THEN pr.TARGET_POP ELSE 0 END)AS '5時間未満',
    MAX(CASE WHEN pr.TIME_CODE = 130 THEN pr.TARGET_POP ELSE 0 END)AS '5時間以上6時間未満',
    MAX(CASE WHEN pr.TIME_CODE = 140 THEN pr.TARGET_POP ELSE 0 END)AS '6時間以上7時間未満',
    MAX(CASE WHEN pr.TIME_CODE = 150 THEN pr.TARGET_POP ELSE 0 END)AS '7時間以上8時間未満',
    MAX(CASE WHEN pr.TIME_CODE = 160 THEN pr.TARGET_POP ELSE 0 END)AS '8時間以上9時間未満',
    MAX(CASE WHEN pr.TIME_CODE = 170 THEN pr.TARGET_POP ELSE 0 END)AS '9時間以上',
    MAX(CASE WHEN pr.TIME_CODE = 180 THEN pr.TARGET_POP ELSE 0 END)AS '不詳'
FROM
    prep AS pr
    INNER JOIN AGE_GRP AS ag ON pr.AGE_CODE = ag.AGE_CODE
GROUP BY
    pr.AGE_CODE
ORDER BY
    pr.AGE_CODE
;