with a1 as(
select pf_code
 , round((inp_yes*1.0 /(inp_yes + inp_no + UNIDENTIFIED)*100),1) as inp
from HOSPITALIZATION
group by pf_code
)
select a1.pf_code as "都道府県コード",b.pf_name as "都道府県名" ,a1.inp as "入院率"
from a1
left join PREFECTURE b
on a1.pf_code = b.pf_code
order by a1.pf_code desc ,a1.inp desc