WITH joined AS (
    SELECT
        ag.age_name,
        st.time_name,
        std.target_pop
    FROM
        sleep_time_dtl AS std
        INNER JOIN sleep_time AS st ON std.time_code = st.time_code
        INNER JOIN age_grp AS ag ON std.age_code = ag.age_code
)
SELECT
    age_name AS '年齢階層',
    sum(
        CASE
            WHEN time_name = '5時間未満' THEN target_pop
            ELSE 0
        END
    ) AS '5時間未満',
    sum(
        CASE
            WHEN time_name = '5時間以上6時間未満' THEN target_pop
            ELSE 0
        END
    ) AS '5時間以上6時間未満',
    sum(
        CASE
            WHEN time_name = '6時間以上7時間未満' THEN target_pop
            ELSE 0
        END
    ) AS '6時間以上7時間未満',
    sum(
        CASE
            WHEN time_name = '7時間以上8時間未満' THEN target_pop
            ELSE 0
        END
    ) AS '7時間以上8時間未満',
    sum(
        CASE
            WHEN time_name = '8時間以上9時間未満' THEN target_pop
            ELSE 0
        END
    ) AS '8時間以上9時間未満',
    sum(
        CASE
            WHEN time_name = '9時間以上' THEN target_pop
            ELSE 0
        END
    ) AS '9時間以上',
    sum(
        CASE
            WHEN time_name = '不詳' THEN target_pop
            ELSE 0
        END
    ) AS '不詳'
FROM
    joined
GROUP BY
    age_name