SELECT
     A.AGE_CODE AS '年齢コード'
    ,A.AGE_NAME AS '年齢階層名'
    ,IFNULL(S.SP_TIME_5, 0) AS '5時間未満'
    ,IFNULL(S.SP_TIME_6, 0) AS '5時間以上6時間未満'
    ,IFNULL(S.SP_TIME_7, 0) AS '6時間以上7時間未満'
    ,IFNULL(S.SP_TIME_8, 0) AS '7時間以上8時間未満'
    ,IFNULL(S.SP_TIME_9, 0) AS '8時間以上9時間未満'
    ,IFNULL(S.SP_TIME_9OVER, 0) AS '9時間以上'
FROM
     AGE_GRP AS A
     LEFT JOIN (
        SELECT
             S.AGE_CODE
            ,SUM(IFNULL(S.SP_TIME_5, 0)) AS SP_TIME_5
            ,SUM(IFNULL(S.SP_TIME_6, 0)) AS SP_TIME_6
            ,SUM(IFNULL(S.SP_TIME_7, 0)) AS SP_TIME_7
            ,SUM(IFNULL(S.SP_TIME_8, 0)) AS SP_TIME_8
            ,SUM(IFNULL(S.SP_TIME_9, 0)) AS SP_TIME_9
            ,SUM(IFNULL(S.SP_TIME_9OVER, 0)) AS SP_TIME_9OVER
        FROM 
            PREFECTURE AS P
            INNER JOIN SLEEP_TIME_DTL AS S ON (P.PF_CODE = S.PF_CODE)
        WHERE 
            P.PF_NAME IN ('北海道','青森県','岩手県','宮城県','福島県')
        GROUP BY
            S.AGE_CODE
    ) AS S
    ON(A.AGE_CODE = S.AGE_CODE)
ORDER BY 
     A.AGE_CODE