select p.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 as h
    inner join PREFECTURE as p
    on h.PF_CODE = p.PF_CODE
  order by "入院率" desc;