SELECT
  HP.PF_CODE as '都道府県コード',
  PF.PF_NAME as '都道府県名',
  ROUND(
    CAST(HP.INP_YES as REAL) /
    CAST((HP.INP_YES + HP.INP_NO + HP.UNIDENTIFIED) as REAL)
    * 100,
    1
  ) as '入院率'
FROM HOSPITALIZATION as HP
  INNER JOIN PREFECTURE as PF
  ON HP.PF_CODE = PF.PF_CODE
ORDER BY
  '入院率' DESC,
  HP.PF_CODE ASC;