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 P
JOIN
  HOSPITALIZATION H
ON
  P.PF_CODE = H.PF_CODE
ORDER BY
  入院率 DESC,
  都道府県コード ASC;