select
    ag.AGE_CODE as 年齢コード,
    ag.AGE_NAME as 年齢階層名,
    sum(ifnull(std.SP_TIME_5,0)) as `5時間未満`,
    sum(ifnull(std.SP_TIME_6,0)) as `5時間以上6時間未満`,
    sum(ifnull(std.SP_TIME_7,0)) as `6時間以上7時間未満`,
    sum(ifnull(std.SP_TIME_8,0)) as `7時間以上8時間未満`,
    sum(ifnull(std.SP_TIME_9,0)) as `8時間以上9時間未満`,
    sum(ifnull(std.SP_TIME_9OVER,0)) as `9時間以上`
from
    AGE_GRP as ag
inner join
    SLEEP_TIME_DTL as std
    on ag.AGE_CODE = std.AGE_CODE
where
    std.PF_CODE in (
        "01000",
        "02000",
        "03000",
        "04000",
        "07000"
    )
group by
    1,2
order by
    1