select
S.AGE_CODE as 年齢コード
,A.AGE_NAME as 年齢階層名
,SUM(S.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 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 IN ("北海道","青森県","岩手県","宮城県","福島県")
GROUP BY
    S.AGE_CODE
ORDER BY
    S.AGE_CODE ASC;