select
S.AGE_CODE as '年齢コード',
A.AGE_NAME as '年齢階層名',
sum(S.SP_TIME_5) as '5時間未満',
sum(S.SP_TIME_6) as '5時間以上6時間未満',
sum(S.SP_TIME_7) as '6時間以上7時間未満',
sum(S.SP_TIME_8) as '7時間以上8時間未満',
sum(S.SP_TIME_9) as '8時間以上9時間未満',
sum(S.SP_TIME_9OVER) as '9時間以上'

from
SLEEP_TIME_DTL as S
left join
AGE_GRP as A on S.AGE_CODE = A.AGE_CODE 
left join
PREFECTURE as P on S.PF_CODE = P.PF_CODE
where
(P.PF_NAME = '北海道' or
P.PF_NAME = '青森県' or
P.PF_NAME = '岩手県' or
P.PF_NAME = '宮城県' or
P.PF_NAME = '福島県')
AND A.AGE_NAME is not null

Group By
A.AGE_NAME