select 
ag.AGE_CODE as '年齢コード',
ag.AGE_NAME as '年齢階層名', 
s.a as '5時間未満',
s.b as '5時間以上6時間未満', 
s.c as '6時間以上7時間未満', 
s.d as '7時間以上8時間未満', 
s.e as '8時間以上9時間未満',
s.f as '9時間以上'

from
PREFECTURE p
join
    (select SUM(SP_TIME_5) as a, 
    SUM(SP_TIME_6) as b,
    SUM(SP_TIME_7) as c,
    SUM(SP_TIME_8) as d,
    SUM(SP_TIME_9) as e,
    SUM(SP_TIME_9OVER) as f,
    AGE_CODE, PF_CODE 
     from SLEEP_TIME_DTL
     where PF_CODE in ('01000','02000','03000','04000','07000')
     GROUP BY AGE_CODE) as s
on p.PF_CODE = s.PF_CODE
join 
     AGE_GRP ag
on ag.AGE_CODE = s.AGE_CODE
order by ag.AGE_CODE