SELECT PREF.PF_CODE,  PREF.PF_NAME, R_INP.'入院率' FROM PREFECTURE AS PREF
JOIN (
  SELECT PF_CODE, ROUND(CAST(INP_YES AS REAL) / (INP_YES + INP_NO + UNIDENTIFIED) * 100, 1) AS '入院率' FROM HOSPITALIZATION
  ) AS R_INP
  ON PREF.PF_CODE = R_INP.PF_CODE
;