SELECT PF_CODE AS "都道府県コード", PF_NAME AS "都道府県名", ROUND(CAST(INP_YES as REAL) * 100 / CAST((INP_YES + INP_NO + UNIDENTIFIED) as REAL), 1) AS "入院率"
FROM HOSPITALIZATION JOIN PREFECTURE USING(PF_CODE)
GROUP BY PF_CODE, PF_NAME
ORDER BY 3 DESC, 1;