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