SELECT
    AGE_NAME
    , SUM(time_code_120) AS [5時間未満]
    , SUM(time_code_130) AS [5時間以上6時間未満]
    , SUM(time_code_140) AS [6時間以上7時間未満]
    , SUM(time_code_150) AS [7時間以上8時間未満]
    , SUM(time_code_160) AS [8時間以上9時間未満]
    , SUM(time_code_170) AS [9時間以上]
    , SUM(time_code_180) AS [不詳]
FROM
    (
    SELECT
        std.AGE_CODE
        , ag.AGE_NAME
        , IIF(TIME_CODE = 120, std.TARGET_POP, 0) AS time_code_120
        , IIF(TIME_CODE = 130, std.TARGET_POP, 0) AS time_code_130
        , IIF(TIME_CODE = 140, std.TARGET_POP, 0) AS time_code_140
        , IIF(TIME_CODE = 150, std.TARGET_POP, 0) AS time_code_150
        , IIF(TIME_CODE = 160, std.TARGET_POP, 0) AS time_code_160
        , IIF(TIME_CODE = 170, std.TARGET_POP, 0) AS time_code_170
        , IIF(TIME_CODE = 180, std.TARGET_POP, 0) AS time_code_180
    FROM
        SLEEP_TIME_DTL AS std
    INNER JOIN
        AGE_GRP AS ag
    ON
        std.AGE_CODE = ag.AGE_CODE
    )
GROUP BY
    AGE_CODE
ORDER BY
    AGE_CODE ASC
;