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
    SLEEP_TIME_DTL as STD
inner join
    SLEEP_TIME as SL on SL.TIME_CODE = STD.TIME_CODE
inner join
    AGE_GRP as AG on AG.AGE_CODE = STD.AGE_CODE
group by
    STD.AGE_CODE
order by
    STD.AGE_CODE
;