select 
  h.PF_CODE "都道府県コード",
  p.PF_NAME "都道府県名",
  replace(round(cast(h.INP_YES as real)/cast((h.INP_YES+h.INP_NO+h.UNIDENTIFIED) as real)*100,1),'.0','') "入院率"
from HOSPITALIZATION "h"
inner join PREFECTURE "p" on (
  h.PF_CODE = p.PF_CODE
)
order by 3 desc, 1
;