SELECT
    AGE_NAME AS 年齢階層
  , T120 AS '5時間未満'
  , T130 AS '5時間以上6時間未満'
  , T140 AS '6時間以上7時間未満'
  , T150 AS '7時間以上8時間未満'
  , T160 AS '8時間以上9時間未満'
  , T170 AS '9時間以上'
  , T180 AS '不詳'
FROM
(
SELECT
    AGE_CODE
  , sum(CASE WHEN TIME_CODE = 120 THEN TARGET_POP ELSE 0 END) AS T120
  , sum(CASE WHEN TIME_CODE = 130 THEN TARGET_POP ELSE 0 END) AS T130
  , sum(CASE WHEN TIME_CODE = 140 THEN TARGET_POP ELSE 0 END) AS T140
  , sum(CASE WHEN TIME_CODE = 150 THEN TARGET_POP ELSE 0 END) AS T150
  , sum(CASE WHEN TIME_CODE = 160 THEN TARGET_POP ELSE 0 END) AS T160
  , sum(CASE WHEN TIME_CODE = 170 THEN TARGET_POP ELSE 0 END) AS T170
  , sum(CASE WHEN TIME_CODE = 180 THEN TARGET_POP ELSE 0 END) AS T180
FROM
    SLEEP_TIME_DTL
GROUP BY
    AGE_CODE
) T_TOTAL
, AGE_GRP AGP
WHERE
    T_TOTAL.AGE_CODE = AGP.AGE_CODE
ORDER BY
    T_TOTAL.AGE_CODE ASC