select
    a.AGE_CODE as '年齢コード',
    a.AGE_NAME as '年齢階層名',
    sum(SP_TIME_5) as "5時間未満",
    sum(SP_TIME_6) as '5時間以上6時間未満',
    sum(SP_TIME_7) as '6時間以上7時間未満',
    sum(SP_TIME_8) as '7時間以上8時間未満',
    sum(SP_TIME_9) as '8時間以上9時間未満',
    sum(SP_TIME_9OVER) as '9時間以上'
from
    sleep_time_dtl s
inner join 
    age_grp a
on s.age_code = a.age_code
inner join
    prefecture p
on s.pf_code = p.pf_code
where
    p.pf_name in  ("北海道","青森県","岩手県","宮城県","福島県")
group by 
    a.age_code
order by
    a.age_code;