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 都道府県コード;