select
    wk1.AGE_CODE as "年齢コード",
    wk2.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 as wk1
inner join
    AGE_GRP as wk2
on
    wk1.AGE_CODE = wk2.AGE_CODE
inner join
    PREFECTURE as wk3
on
    wk1.PF_CODE = wk3.PF_CODE
where
    wk3.PF_NAME = "北海道" or
    wk3.PF_NAME = "青森県" or
    wk3.PF_NAME = "岩手県" or
    wk3.PF_NAME = "宮城県" or
    wk3.PF_NAME = "福島県"
group by
    年齢コード
order by
    年齢コード asc
;