SELECT
  PREF.PF_CODE,
  PF_NAME,
  ROUND(CAST(INP_YES AS REAL) * 100 / CAST(INP_YES + INP_NO + UNIDENTIFIED AS REAL), 1) AS 入院率
FROM
  HOSPITALIZATION AS HOS
  INNER JOIN
    PREFECTURE AS PREF
    ON HOS.PF_CODE = PREF.PF_CODE
ORDER BY 3 DESC, 1 ASC;