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