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