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