select
    std.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 std
inner join
    age_grp ag
on  std.age_code    =   ag.age_code
inner join
    prefecture  p
on  std.pf_code =   p.pf_code
where
    1   =   1
and p.pf_name  in  ('北海道', '青森県', '岩手県', '宮城県', '福島県')
group by
    std.age_code
order by
    std.age_code
;