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