select
p.pf_code 都道府県コード,
p.pf_name 都道府県名,
case 
  when cast(format("%.02f", (inp_yes * 100.0) / (inp_yes + inp_no + UNIDENTIFIED)) as string) like '%.00' then cast(format("%d", (inp_yes * 100.0) / (inp_yes + inp_no + UNIDENTIFIED)) as string)
  else  cast(format("%.02f", (inp_yes * 100.0) / (inp_yes + inp_no + UNIDENTIFIED)) as string) 
end    入院率
from HOSPITALIZATION h
left join PREFECTURE p
 on p.PF_CODE = h.PF_CODE