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