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