SELECT hosp.PF_CODE as 都道府県コード,
       pref.PF_NAME as 都道府県名,
       ROUND(
            CAST(hosp.INP_YES AS REAL) /
            CAST((hosp.INP_YES + hosp.INP_NO + hosp.UNIDENTIFIED) AS REAL)
            * 100, 1) as 入院率
FROM HOSPITALIZATION as hosp
    INNER JOIN PREFECTURE as pref
    ON hosp.PF_CODE == pref.PF_CODE
order by 
    入院率 DESC,
    都道府県コード