SELECT
    AG.AGE_NAME as "年齢階層"
    , SUM(
        CASE
            WHEN DTL.TIME_CODE=120 THEN DTL.TARGET_POP ELSE 0
        END
    ) as "5時間未満"
    , SUM(
        CASE
            WHEN DTL.TIME_CODE=130 THEN DTL.TARGET_POP ELSE 0
        END
    ) as "5時間以上6時間未満"
    , SUM(
        CASE
            WHEN DTL.TIME_CODE=140 THEN DTL.TARGET_POP ELSE 0
        END
    ) as "6時間以上7時間未満"
    , SUM(
        CASE
            WHEN DTL.TIME_CODE=150 THEN DTL.TARGET_POP ELSE 0
        END
    ) as "7時間以上8時間未満"
    , SUM(
        CASE
            WHEN DTL.TIME_CODE=160 THEN DTL.TARGET_POP ELSE 0
        END
    ) as "8時間以上9時間未満"
    , SUM(
        CASE
            WHEN DTL.TIME_CODE=170 THEN DTL.TARGET_POP ELSE 0
        END
    ) as "9時間以上"
    , SUM(
        CASE
            WHEN DTL.TIME_CODE=180 THEN DTL.TARGET_POP ELSE 0
        END
    ) as "不詳"
FROM
    SLEEP_TIME_DTL as DTL
    INNER JOIN SLEEP_TIME as SL
        ON SL.TIME_CODE = DTL.TIME_CODE
    INNER JOIN AGE_GRP as AG
        ON AG.AGE_CODE = DTL.AGE_CODE
GROUP BY AG.AGE_NAME
ORDER BY
    DTL.AGE_CODE ASC;