SELECT PR.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
LEFT JOIN PREFECTURE AS PR
ON HO.PF_CODE  = PR.PF_CODE 
--WHERE
--GROUP BY PR.PF_CODE
--,PR.PF_NAME
ORDER BY 入院率 desc,
都道府県コード asc;