SELECT
    T2.PF_CODE AS 都道府県コード,
    T1.PF_NAME AS 都道府県名,
    ROUND(CAST(T2.INP_YES AS FLOAT) / (CAST(T2.INP_YES AS FLOAT) + CAST(T2.INP_NO AS FLOAT) + CAST(T2.UNIDENTIFIED AS FLOAT)) * 100, 1) AS 入院率
FROM
    PREFECTURE AS T1
RIGHT JOIN
    HOSPITALIZATION AS T2 ON T1.PF_CODE = T2.PF_CODE
ORDER BY
    入院率 DESC, 都道府県コード;