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