SELECT
g.AGE_CODE as 年齢コード,
g.AGE_NAME as 年齢階層,
SL."5時間未満",
SL."5時間以上6時間未満",
SL."6時間以上7時間未満",
SL."7時間以上8時間未満",
SL."8時間以上9時間未満",
SL."9時間以上"
FROM
AGE_GRP g
JOIN
(SELECT
d.AGE_CODE,
SUM(d.SP_TIME_5) as "5時間未満",
SUM(d.SP_TIME_6) as "5時間以上6時間未満",
SUM(d.SP_TIME_7) as "6時間以上7時間未満",
SUM(d.SP_TIME_8) as "7時間以上8時間未満",
SUM(d.SP_TIME_9) as "8時間以上9時間未満",
SUM(d.SP_TIME_9OVER) as "9時間以上"
FROM
SLEEP_TIME_DTL d
WHERE d.PF_CODE IN ('01000','02000','03000','04000','07000')
GROUP BY d.AGE_CODE) SL
ON
g.AGE_CODE = SL.AGE_CODE
ORDER BY g.AGE_CODE