select
age_grp.age_code as 年齢コード,
age_grp.age_name as 年齢階層名,
sum(coalesce(sleep_time_dtl.sp_time_5, 0)) as '5時間未満',
sum(coalesce(sleep_time_dtl.sp_time_6, 0)) as '5時間以上6時間未満',
sum(coalesce(sleep_time_dtl.sp_time_7, 0)) as '6時間以上7時間未満',
sum(coalesce(sleep_time_dtl.sp_time_8, 0)) as '7時間以上8時間未満',
sum(coalesce(sleep_time_dtl.sp_time_9, 0)) as '8時間以上9時間未満',
sum(coalesce(sleep_time_dtl.sp_time_9over, 0)) as '9時間以上'
from
age_grp
left join
sleep_time_dtl
on
age_grp.age_code = sleep_time_dtl.age_code
group by
age_grp.age_code,
age_grp.age_name
order by
age_grp.age_code asc