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