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