SELECT
      h.PF_CODE as '都道府県コード'
    , PF_NAME as '都道府県名'
    , ROUND((INP_YES * 100.0) / (INP_YES + INP_NO + UNIDENTIFIED), 1) as '入院率'
FROM
      HOSPITALIZATION h
    INNER JOIN
      PREFECTURE p
    ON h.PF_CODE = p.PF_CODE
ORDER BY
      ROUND((INP_YES * 100.0) / (INP_YES + INP_NO + UNIDENTIFIED), 1) Desc
    , h.PF_CODE