select std.AGE_CODE as "年齢コード"
,ag.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 std
left join PREFECTURE as pf on std.pf_code = pf.pf_code
left join AGE_GRP as ag on std.age_code = ag.age_code
where pf.PF_NAME in ("北海道","青森県","岩手県","宮城県","福島県")
and ag.age_name is not null
group by age_name
order by 1