SELECT
AG.AGE_NAME AS "年齢階層",
STD.POP_120 AS "5時間未満",
STD.POP_130 AS "5時間以上6時間未満",
STD.POP_140 AS "6時間以上7時間未満",
STD.POP_150 AS "7時間以上8時間未満",
STD.POP_160 AS "8時間以上9時間未満",
STD.POP_170 AS "9時間以上",
STD.POP_180 AS "不詳"
FROM (
  SELECT AGE_CODE,
    SUM(CASE WHEN TIME_CODE = '120' THEN TARGET_POP ELSE 0 END) AS POP_120,
    SUM(CASE WHEN TIME_CODE = '130' THEN TARGET_POP ELSE 0 END) AS POP_130,
    SUM(CASE WHEN TIME_CODE = '140' THEN TARGET_POP ELSE 0 END) AS POP_140,
    SUM(CASE WHEN TIME_CODE = '150' THEN TARGET_POP ELSE 0 END) AS POP_150,
    SUM(CASE WHEN TIME_CODE = '160' THEN TARGET_POP ELSE 0 END) AS POP_160,
    SUM(CASE WHEN TIME_CODE = '170' THEN TARGET_POP ELSE 0 END) AS POP_170,
    SUM(CASE WHEN TIME_CODE = '180' THEN TARGET_POP ELSE 0 END) AS POP_180
  FROM SLEEP_TIME_DTL
  GROUP BY AGE_CODE
) STD
INNER JOIN AGE_GRP AG
ON STD.AGE_CODE = AG.AGE_CODE
ORDER BY STD.AGE_CODE