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