select
dtl.age_code as "年齢コード",
age.age_name as "年齢階層名",
sum(sp_time_5) as "5時間未満",
sum(sp_time_6) as "5時間以上6時間未満",
sum(sp_time_7) as "6時間以上7時間未満",
sum(sp_time_8) as "7時間以上8時間未満",
sum(sp_time_9) as "8時間以上9時間未満",
sum(sp_time_9over) as "9時間以上"
from
sleep_time_dtl dtl
inner join age_grp age
on dtl.age_code = age.age_code
inner join prefecture pref
on dtl.pf_code = pref.pf_code
where
dtl.pf_code in ('01000', '02000', '03000', '04000', '07000')
group by
dtl.age_code
order by
dtl.age_code asc