select 
    st.AGE_CODE as "年齢コード"
    ,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 st
join AGE_GRP a on st.age_code=a.age_code
left join PREFECTURE p on st.PF_CODE=p.PF_CODE
where pf_name in("北海道", "青森県", "岩手県", "宮城県", "福島県")
group by 1,2
order by 1,2