SELECT
    STD.age_code AS 年齢コード
    , AGE.age_name AS 年齢階層名
    , sum(STD.sp_time_5) AS "5時間未満"
    , sum(STD.sp_time_6) AS "5時間以上6時間未満"
    , sum(STD.sp_time_7) AS "6時間以上7時間未満"
    , sum(STD.sp_time_8) AS "7時間以上8時間未満"
    , sum(STD.sp_time_9) AS "8時間以上9時間未満"
    , sum(STD.sp_time_9over) AS "9時間以上" 
FROM
    sleep_time_dtl std 
    LEFT OUTER JOIN age_grp age 
        ON STD.age_code = AGE.age_code 
    LEFT OUTER JOIN prefecture pf 
        ON STD.pf_code = PF.pf_code 
WHERE
    STD.pf_code IN ('01000', '02000', '03000', '04000', '07000') 
    group by STD.age_code
ORDER BY
    STD.age_code ASC