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