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