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