select
 ag.age_code as `年齢コード`,
 ag.age_name as `年齢階層名`,
 sum(std.sp_time_5) as `5時間未満`,
 sum(std.sp_time_6) as `5時間以上6時間未満`,
 sum(std.sp_time_7) as `6時間以上7時間未満`,
 sum(std.sp_time_8) as `7時間以上8時間未満`,
 sum(std.sp_time_9) as `8時間以上9時間未満`,
 sum(std.sp_time_9over) as `9時間以上`
from
 sleep_time_dtl as std
inner join
 prefecture as p
on
 std.pf_code=p.pf_code
inner join
 age_grp as ag
on
 std.age_code=ag.age_code
where
 std.pf_code in ('01000','02000','03000','04000','07000')
group by
 1,2
order by
 1