select 
    DTL.AGE_CODE    as 年齢コード
    ,GRP.AGE_NAME   as 年齢階層名
    ,sum(DTL.SP_TIME_5)  as "5時間未満"
    ,sum(DTL.SP_TIME_6)  as "5時間以上6時間未満"
    ,sum(DTL.SP_TIME_7)  as "6時間以上7時間未満"
    ,sum(DTL.SP_TIME_8)  as "7時間以上8時間未満"
    ,sum(DTL.SP_TIME_9)  as "8時間以上9時間未満"
    ,sum(DTL.SP_TIME_9OVER) as "9時間以上"
from
    SLEEP_TIME_DTL as DTL
inner join AGE_GRP as GRP
    on GRP.AGE_CODE = DTL.AGE_CODE
where PF_CODE in('01000','02000','03000','04000','07000')
group by DTL.AGE_CODE
order by DTL.AGE_CODE asc