SELECT

SLEEP_TIME_DTL.AGE_CODE AS 年齢コード,
--PREFECTURE.PF_NAME,
AGE_GRP.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

JOIN AGE_GRP 
ON AGE_GRP.AGE_CODE = SLEEP_TIME_DTL.AGE_CODE
s
JOIN PREFECTURE
ON PREFECTURE.PF_CODE = SLEEP_TIME_DTL.PF_CODE

--北海道、青森県、岩手県、宮城県、福島県
WHERE
   PREFECTURE.PF_NAME IN ( '北海道','青森県', '岩手県', '宮城県', '福島県')
--
GROUP BY
SLEEP_TIME_DTL.AGE_CODE
--PREFECTURE.PF_NAME
--年齢コードの昇順
ORDER BY
SLEEP_TIME_DTL.AGE_CODE