select 
    AG.AGE_NAME as 年齢階層,
    SUM(
    CASE
        WHEN ST.TIME_NAME = '5時間未満' THEN STD.TARGET_POP
        ELSE 0
    END
    ) as '5時間未満',
    SUM(CASE
        WHEN ST.TIME_NAME = '5時間以上6時間未満' THEN STD.TARGET_POP
        ELSE 0
    END
    ) as '5時間以上6時間未満',
    SUM(CASE
        WHEN ST.TIME_NAME = '6時間以上7時間未満' THEN STD.TARGET_POP
        ELSE 0
    END
    ) as '6時間以上7時間未満',
    SUM(CASE
        WHEN ST.TIME_NAME = '7時間以上8時間未満' THEN STD.TARGET_POP
        ELSE 0
    END
    ) as '7時間以上8時間未満',
    SUM(CASE
        WHEN ST.TIME_NAME = '8時間以上9時間未満' THEN STD.TARGET_POP
        ELSE 0
    END
    ) as '8時間以上9時間未満',
    SUM(CASE
        WHEN ST.TIME_NAME = '9時間以上' THEN STD.TARGET_POP
        ELSE 0
    END
    ) as '9時間以上',
    SUM(CASE
        WHEN ST.TIME_NAME = '不詳' THEN STD.TARGET_POP
        ELSE 0
    END
    ) as '不詳'
from
    SLEEP_TIME_DTL as STD
    inner join AGE_GRP as AG
    on STD.AGE_CODE  = AG.AGE_CODE
    inner join SLEEP_TIME as ST
    on ST.TIME_CODE = STD.TIME_CODE
group by
    STD.AGE_CODE
order by
    STD.AGE_CODE ASC