SELECT HO.PF_CODE AS 都道府県コード,
PR.PF_NAME AS 都道府県名,
ROUND (CAST(HO.INP_YES AS REAL)/CAST((HO.INP_YES+HO.INP_NO+HO.UNIDENTIFIED)AS REAL)*100,1) AS 入院率

FROM HOSPITALIZATION AS HO

INNER JOIN PREFECTURE AS PR
ON HO.PF_CODE = PR.PF_CODE

ORDER BY 入院率 DESC,
      HO.PF_CODE ASC;