select AGE_SUM.AGE_CODE as '年齢コード', GRP.AGE_NAME as '年齢階層名', AGE_SUM.SUM5 as '5時間未満', 
       AGE_SUM.SUM6 as '5時間以上6時間未満', AGE_SUM.SUM7 as '6時間以上7時間未満', 
       AGE_SUM.SUM8 as '7時間以上8時間未満', AGE_SUM.SUM9 as '8時間以上9時間未満', AGE_SUM.SUM9OVER as '9時間以上'
from (select AGE_CODE, SUM(SP_TIME_5) as SUM5, SUM(SP_TIME_6) as SUM6, SUM(SP_TIME_7) as SUM7, SUM(SP_TIME_8) as SUM8, SUM(SP_TIME_9) as SUM9, SUM(SP_TIME_9OVER) as SUM9OVER 
from SLEEP_TIME_DTL where PF_CODE in (select PF_CODE from PREFECTURE where PF_NAME in ('北海道','青森県','岩手県', '宮城県', '福島県'))
group by AGE_CODE
) AGE_SUM,
AGE_GRP GRP
where AGE_SUM.AGE_CODE=GRP.AGE_CODE
order by '年齢コード' asc
;