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