select
 t2.PF_CODE '都道府県コード'
 ,t2.PF_NAME '都道府県名'
 ,ROUND(cast(t1.INP_YES as REAL )/ cast(t1.INP_YES+t1.INP_NO+t1.UNIDENTIFIED as REAL)*100,1) '入院率'
from
 HOSPITALIZATION as t1
join
 PREFECTURE as t2
on
 t1.PF_CODE=t2.PF_CODE
order by 3 desc