SELECT 
    ag.AGE_NAME,
    SUM(CASE WHEN s.time_code = 120 THEN s.target_pop ELSE 0 END) as '5時間未満',
    SUM(CASE WHEN s.time_code = 130 THEN s.target_pop ELSE 0 END) as '5時間以上6時間未満',
    SUM(CASE WHEN s.time_code = 140 THEN s.target_pop ELSE 0 END) as '6時間以上7時間未満',
    SUM(CASE WHEN s.time_code = 150 THEN s.target_pop ELSE 0 END) as '7時間以上8時間未満',
    SUM(CASE WHEN s.time_code = 160 THEN s.target_pop ELSE 0 END) as '8時間以上9時間未満',
    SUM(CASE WHEN s.time_code = 170 THEN s.target_pop ELSE 0 END) as '9時間以上',
    SUM(CASE WHEN s.time_code = 180 THEN s.target_pop ELSE 0 END) as 不詳
FROM age_grp ag
    JOIN sleep_time_dtl s
        ON s.age_code = ag.age_code
GROUP BY ag.age_code
ORDER BY ag.age_code