SELECT ag.AGE_NAME AS "年齢階層"
     , slp.TARGET_POP120 AS "5時間未満"
     , slp.TARGET_POP130 AS "5時間以上6時間未満"
     , slp.TARGET_POP140 AS "6時間以上7時間未満"
     , slp.TARGET_POP150 AS "7時間以上8時間未満"
     , slp.TARGET_POP160 AS "8時間以上9時間未満"
     , slp.TARGET_POP170 AS "9時間以上"
     , slp.TARGET_POP180 AS "不詳"
  FROM (
       SELECT slp.AGE_CODE
            , SUM(slp.TARGET_POP) AS TARGET_POP
            , SUM(
                 CASE slp.TIME_CODE
                      WHEN 120 THEN TARGET_POP
                      ELSE 0 END
                 ) AS TARGET_POP120
            , SUM(
                 CASE slp.TIME_CODE
                      WHEN 130 THEN TARGET_POP
                      ELSE 0 END
                 ) AS TARGET_POP130
            , SUM(
                 CASE slp.TIME_CODE
                      WHEN 140 THEN TARGET_POP
                      ELSE 0 END
                 ) AS TARGET_POP140
            , SUM(
                 CASE slp.TIME_CODE
                      WHEN 150 THEN TARGET_POP
                      ELSE 0 END
                 ) AS TARGET_POP150
            , SUM(
                 CASE slp.TIME_CODE
                      WHEN 160 THEN TARGET_POP
                      ELSE 0 END
                 ) AS TARGET_POP160
            , SUM(
                 CASE slp.TIME_CODE
                      WHEN 170 THEN TARGET_POP
                      ELSE 0 END
                 ) AS TARGET_POP170
            , SUM(
                 CASE slp.TIME_CODE
                      WHEN 180 THEN TARGET_POP
                      ELSE 0 END
                 ) AS TARGET_POP180
         FROM SLEEP_TIME_DTL slp
        GROUP BY slp.AGE_CODE
       ) AS slp
       LEFT OUTER JOIN AGE_GRP ag
                    ON slp.AGE_CODE = ag.AGE_CODE
 ORDER BY slp.AGE_CODE asc
;