select
    ag.AGE_NAME as `年齢階層`,
    sum(case when std.TIME_CODE = 120 then std.TARGET_POP end) as `5時間未満`,
    sum(case when std.TIME_CODE = 130 then std.TARGET_POP end) as `5時間以上6時間未満`,
    sum(case when std.TIME_CODE = 140 then std.TARGET_POP end) as `6時間以上7時間未満`,
    sum(case when std.TIME_CODE = 150 then std.TARGET_POP end) as `7時間以上8時間未満`,
    sum(case when std.TIME_CODE = 160 then std.TARGET_POP end) as `8時間以上9時間未満`,
    sum(case when std.TIME_CODE = 170 then std.TARGET_POP end) as `9時間以上`,
    sum(case when std.TIME_CODE = 180 then std.TARGET_POP end) as `不詳`
from
    AGE_GRP as ag
inner join
    SLEEP_TIME_DTL as std
    on ag.AGE_CODE = std.AGE_CODE
group by
    ag.AGE_CODE
order by
    ag.AGE_CODE