SELECT h.PF_CODE AS "都道府県コード",
p.PF_NAME AS "都道府県名",
round((cast(INP_YES as real)/cast(INP_YES+INP_NO+UNIDENTIFIED as real))*100,1) AS "入院率"
FROM HOSPITALIZATION AS h
INNER JOIN PREFECTURE AS p ON h.PF_CODE = p.PF_CODE
GROUP BY h.PF_CODE
ORDER BY 入院率 DESC;