SELECT AGE_GRP.AGE_NAME AS 年齢階層,
SUM(a.TARGET_POP) AS '5時間未満',
SUM(b.TARGET_POP) AS '5時間以上6時間未満',
SUM(c.TARGET_POP) AS '6時間以上7時間未満',
SUM(d.TARGET_POP) AS '7時間以上8時間未満',
SUM(e.TARGET_POP) AS '8時間以上9時間未満',
SUM(f.TARGET_POP) AS '9時間以上',
SUM(g.TARGET_POP) AS 不詳
FROM AGE_GRP
JOIN SLEEP_TIME_DTL AS a ON AGE_GRP.AGE_CODE = a.AGE_CODE AND a.TIME_CODE = 120
JOIN SLEEP_TIME_DTL AS b ON AGE_GRP.AGE_CODE = b.AGE_CODE AND b.TIME_CODE = 130
JOIN SLEEP_TIME_DTL AS c ON AGE_GRP.AGE_CODE = c.AGE_CODE AND c.TIME_CODE = 140
JOIN SLEEP_TIME_DTL AS d ON AGE_GRP.AGE_CODE = d.AGE_CODE AND d.TIME_CODE = 150
JOIN SLEEP_TIME_DTL AS e ON AGE_GRP.AGE_CODE = e.AGE_CODE AND e.TIME_CODE = 160
JOIN SLEEP_TIME_DTL AS f ON AGE_GRP.AGE_CODE = f.AGE_CODE AND f.TIME_CODE = 170
JOIN SLEEP_TIME_DTL AS g ON AGE_GRP.AGE_CODE = g.AGE_CODE AND g.TIME_CODE = 180
GROUP BY a.AGE_CODE