select
    HOS.PF_CODE AS '都道府県コード'
    ,PRE.PF_NAME AS '都道府県名'
    , ROUND((HOS.INP_YES/(HOS.INP_YES + HOS.INP_NO + HOS.UNIDENTIFIED)) * 1000, 2) AS '入院率'
FROM HOSPITALIZATION HOS
    LEFT JOIN PREFECTURE PRE
        ON HOS.PF_CODE = PRE.PF_CODE
ORDER BY 3 DESC, 1 ASC
;