SELECT
  HOS.PF_CODE AS '都道府県コード',
  PREF.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 AS HOS
LEFT JOIN
  PREFECTURE AS PREF ON PREF.PF_CODE = HOS.PF_CODE
ORDER BY
  3 DESC, 1