select
    std.age_code           as 年齢コード
,   age.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 age
on
    age.age_code = std.age_code
inner join
    PREFECTURE prf
on
    prf.pf_code = std.pf_code
where
    prf.pf_name in ('北海道','青森県','岩手県','宮城県','福島県')
group by
    std.age_code
,   age.age_name
order by
    std.age_code