select t2.PF_NAME,
    round(cast(INP_YES as real)/(cast(INP_YES as real) + cast(INP_NO as real) + cast(UNIDENTIFIED as real))*100) as "入院率"
from HOSPITALIZATION as t1
    INNER JOIN PREFECTURE as t2
on t1.PF_CODE == t2.PF_CODE
order by 入院率 asc, t2.PF_CODE desc;