SELECT HO.PF_CODE AS 都道府県コード
,PR.PF_NAME AS 都道府県名
,ROUND(CAST(HO.INP_YES AS REAL)/(CAST(HO.INP_YES AS REAL)+CAST(HO.INP_NO AS REAL)+CAST(HO.UNIDENTIFIED AS REAL))*100,1) AS 入院率
FROM HOSPITALIZATION AS HO
LEFT JOIN PREFECTURE AS PR
       ON HO.PF_CODE = PR.PF_CODE
--WHERE 
GROUP BY HO.PF_CODE
ORDER BY 入院率 DESC,都道府県コード ASC