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