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