SELECT AGE.AGE_CODE as "年齢コード", AGE.AGE_NAME as "年齢階層名", SP_TIME_5 as "5時間未満", SP_TIME_6 as "5時間以上6時間未満", SP_TIME_7 as "6時間以上7時間未満", SP_TIME_8 as "7時間以上8時間未満", SP_TIME_9 as "8時間以上9時間未満", SP_TIME_9OVER as "9時間以上" 
FROM SLEEP_TIME_DTL AS SLEEP 
JOIN AGE_GRP AS AGE 
ON SLEEP.AGE_CODE = AGE.AGE_CODE
JOIN PREFECTURE
ON SLEEP.PF_CODE = PREFECTURE.PF_CODE
WHERE PREFECTURE.PF_NAME IN ("北海道","青森県","岩手県","宮城県","福島")
GROUP BY AGE.AGE_CODE
ORDER BY AGE.AGE_CODE ASC;