SELECT
    PREFECTURE.PF_CODE AS '都道府県コード'
    , PREFECTURE.PF_NAME AS '都道府県名'
    , round(HOSPITALIZATION.INP_YES / cast((HOSPITALIZATION.INP_YES + HOSPITALIZATION.INP_NO + HOSPITALIZATION.UNIDENTIFIED) AS REAL) * 100, 1) AS '入院率'
FROM
    PREFECTURE
    INNER JOIN HOSPITALIZATION
        USING(PF_CODE)
ORDER BY
  入院率 DESC
  , 都道府県コード
;