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