SELECT
        AGE.AGE_CODE AS '年齢コード'
       ,AGE.AGE_NAME AS '年齢階層名'
       ,SUM(SLE.SP_TIME_5) AS '5時間未満'
       ,SUM(SLE.SP_TIME_6) AS '5時間以上6時間未満'
       ,SUM(SLE.SP_TIME_7) AS '6時間以上7時間未満'
       ,SUM(SLE.SP_TIME_8) AS '7時間以上8時間未満'
       ,SUM(SLE.SP_TIME_9) AS '8時間以上9時間未満'
       ,SUM(SLE.SP_TIME_9OVER) AS '9時間以上'
    FROM
        AGE_GRP  AGE
       ,PREFECTURE PRE
       ,SLEEP_TIME_DTL SLE
    WHERE
        -- 集計対象は以下の都道府県のみ
        PRE.PF_NAME IN ('北海道', '青森県', '岩手県', '宮城県', '福島県')
        -- 絞り込んだ都道府県コードを使用
    AND PRE.PF_CODE  = SLE.PF_CODE
    AND SLE.AGE_CODE = AGE.AGE_CODE
    GROUP BY
        AGE.AGE_CODE
    ORDER BY
        AGE.AGE_CODE ASC
;