select
    std.age_code      as 年齢コード
,   age.age_name      as 年齢階層名
,   std.sp_time_5     as "5時間未満"
,   std.sp_time_6     as "5時間以上6時間未満"
,   std.sp_time_7     as "6時間以上7時間未満"
,   std.sp_time_8     as "7時間以上8時間未満"
,   std.sp_time_9     as "8時間以上9時間未満"
,   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 ('北海道','青森県','岩手県','宮城県','福島県')
order by
    std.age_code