SELECT 
    A.PF_CODE AS 都道府県コード, 
    B.PF_NAME AS 都道府県名, 
    CAST(1000.0 * A.INP_YES / (A.INP_YES + A.INP_NO + A.UNIDENTIFIED) + 0.5 AS INTEGER) / 10.0 AS 入院率
FROM HOSPITALIZATION AS A
INNER JOIN PREFECTURE AS B
ON A.PF_CODE = B.PF_CODE
ORDER BY 入院率 DESC, A.PF_CODE;