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