SELECT *
FROM (
  SELECT
    PREFECTURE.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 PREFECTURE
  LEFT JOIN HOSPITALIZATION ON HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
  GROUP BY PREFECTURE.PF_CODE, PREFECTURE.PF_NAME
)
ORDER BY "入院率" DESC, cast("都道府県コード" AS INTEGER) ASC