select
SLEEP_TIME_DTL.AGE_CODE as 年齢コード,
AGE_GRP.AGE_NAME as 年齢階層名,
sum(case SLEEP_TIME_DTL.AGE_CODE when 200 then SP_TIME_5 else 0 end) as "5時間未満",
sum(case SLEEP_TIME_DTL.AGE_CODE when 210 then SP_TIME_6 else 0 end) as "5時間以上6時間未満",
sum(case SLEEP_TIME_DTL.AGE_CODE when 240 then SP_TIME_7 else 0 end) as "6時間以上7時間未満",
sum(case SLEEP_TIME_DTL.AGE_CODE when 250 then SP_TIME_8 else 0 end) as "7時間以上8時間未満",
sum(case SLEEP_TIME_DTL.AGE_CODE when 280 then SP_TIME_9 else 0 end) as "8時間以上9時間未満",
sum(case SLEEP_TIME_DTL.AGE_CODE when 200 then SP_TIME_9OVER else 0 end) as "9時間以上"
from SLEEP_TIME_DTL
inner join AGE_GRP
on SLEEP_TIME_DTL.AGE_CODE = AGE_GRP.AGE_CODE
where SLEEP_TIME_DTL.PF_CODE in('01000','02000','03000','04000','07000')
group by SLEEP_TIME_DTL.AGE_CODE;