SELECT A.PF_CODE AS '都道府県コード',PF_NAME AS '都道府県名',ROUND(INP_YES * 100.0 / (INP_YES + INP_NO + UNIDENTIFIED),1)AS '入院率'
FROM HOSPITALIZATION AS A
JOIN PREFECTURE AS B
ON A.PF_CODE = B.PF_CODE
ORDER BY 入院率 DESC;