SELECT
    T2.PF_NAME AS 都道府県 
    ,ROUND(CAST(T1.INP_YES AS REAL)*100/CAST(T1.INP_YES+T1.INP_NO+T1.UNIDENTIFIED AS REAL),1) AS 入院率
FROM
    HOSPITALIZATION AS T1
LEFT OUTER JOIN
    PREFECTURE AS T2
ON
    T1.PF_CODE = T2.PF_CODE
WHERE
    入院率
ORDER BY 入院率 DESC,T1.PF_CODE ASC;