select
hospitalization.pf_code as 都道府県コード,
prefecture.pf_name as 都道府県名,
round(   (cast(hospitalization.inp_yes as real)  /
cast((hospitalization.inp_yes
+hospitalization.inp_no+unidentified)as real))*100,1) as 入院率
from hospitalization
join prefecture on prefecture.pf_code = hospitalization.pf_code
group by hospitalization.pf_code
order by 入院率 desc, hospitalization.pf_code asc;