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