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