select
age_grp.age_code as 年齢コード,
age_grp.age_name as 年齢階層名,
sum(coalesce(std.sp_time_5, 0)) as '5時間未満',
sum(coalesce(std.sp_time_6, 0)) as '5時間以上6時間未満',
sum(coalesce(std.sp_time_7, 0)) as '6時間以上7時間未満',
sum(coalesce(std.sp_time_8, 0)) as '7時間以上8時間未満',
sum(coalesce(std.sp_time_9, 0)) as '8時間以上9時間未満',
sum(coalesce(std.sp_time_9over, 0)) as '9時間以上'
from
age_grp
left join
(
    select
        SLEEP_TIME_DTL.*
    from
        PREFECTURE
    left join
        SLEEP_TIME_DTL
    on
        PREFECTURE.pf_code = SLEEP_TIME_DTL.pf_code
    where
        PREFECTURE.pf_name in ('北海道','青森県','岩手県','宮城県','福島県')
) as std
on
age_grp.age_code = std.age_code
group by
age_grp.age_code,
age_grp.age_name
order by
age_grp.age_code asc