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