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