select tbl.age_code as '年齢コード', 
       age.age_name as '年齢階層名',
       time_5 as '5時間未満', 
       time_6 as '5時間以上6時間未満', 
       time_7 as '6時間以上7時間未満', 
       time_8 as '7時間以上8時間未満', 
       time_9 as '8時間以上9時間未満', 
       time_9over as '9時間以上'
 from (
        select age_code, 
               sum(sp_time_5) as time_5, 
               sum(sp_time_6) as time_6,
               sum(sp_time_7) as time_7,
               sum(sp_time_8) as time_8,
               sum(sp_time_9) as time_9,
               sum(sp_time_9over) as time_9over
          from sleep_time_dtl
         where pf_code in ('01000', '02000', '03000', '04000', '07000')
         group by age_code
        ) tbl
 inner join AGE_GRP age on age.age_code = tbl.age_code
 order by tbl.age_code