SELECT
    ST.AGE_CODE as 年齢コード,
    AG.AGE_NAME as 年齢階層名,
    ST.SP_TIME_5 as "5時間未満",
    ST.SP_TIME_6 as "5時間以上6時間未満",
    ST.SP_TIME_7 as "6時間以上7時間未満",
    ST.SP_TIME_8 as "7時間以上8時間未満",
    ST.SP_TIME_9 as "8時間以上9時間未満",
    ST.SP_TIME_9OVER as "9時間以上"
from
    SLEEP_TIME_DTL as ST
    INNER JOIN AGE_GRP as AG
        ON ST.AGE_CODE = AG.AGE_CODE
    INNER JOIN PREFECTURE as PF
        on ST.PF_CODE = PF.PF_CODE
WHERE
    PF.PF_NAME = "北海道" OR
    PF.PF_NAME = "青森県" OR
    PF.PF_NAME = "岩手県" OR
    PF.PF_NAME = "宮城県" OR
    PF.PF_NAME = "福島県"
ORDER BY
    ST.AGE_CODE ASC;