WITH C_SLEEP_TIME_DTL AS(
    SELECT
        AGE_CODE,
        SUM(CASE
            WHEN TIME_CODE = 120
            THEN TARGET_POP
            ELSE 0
            END) AS "5時間未満",
        SUM(CASE
            WHEN TIME_CODE = 130
            THEN TARGET_POP
            ELSE 0
            END) AS "5時間以上6時間未満",
        SUM(CASE
            WHEN TIME_CODE = 140
            THEN TARGET_POP
            ELSE 0
            END) AS "6時間以上7時間未満",       
        SUM(CASE
            WHEN TIME_CODE = 150
            THEN TARGET_POP
            ELSE 0
            END) AS "7時間以上8時間未満",
        SUM(CASE
            WHEN TIME_CODE = 160
            THEN TARGET_POP
            ELSE 0
            END) AS "8時間以上9時間未満",
        SUM(CASE
            WHEN TIME_CODE = 170
            THEN TARGET_POP
            ELSE 0
            END) AS "9時間以上",
        SUM(CASE
            WHEN TIME_CODE = 180
            THEN TARGET_POP
            ELSE 0
            END) AS "不詳"
    FROM
        SLEEP_TIME_DTL
    GROUP BY
        AGE_CODE
)
SELECT
    t2.AGE_NAME AS "年齢階層",
    t1."5時間未満",
    t1."5時間以上6時間未満",
    t1."6時間以上7時間未満",
    t1."7時間以上8時間未満",
    t1."8時間以上9時間未満",
    t1."9時間以上",
    t1."不詳"
FROM
    C_SLEEP_TIME_DTL AS t1
LEFT JOIN AGE_GRP AS t2
    ON t1.AGE_CODE = t2.AGE_CODE
ORDER BY
    t1.AGE_CODE ASC