with x as (
select
  H.PF_CODE as "都道府県コード",
  P.PF_NAME as "都道府県名",
  round(cast(H.INP_YES as REAL) / cast((H.INP_YES + H.INP_NO + H.UNIDENTIFIED) as REAL) * 100, 1) as "入院率"
from HOSPITALIZATION H, PREFECTURE P
where H.PF_CODE = P.PF_CODE
)
select *
from x
order by "入院率" desc, "都道府県コード"
;