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