select
 p.pf_code 都道府県コード,
 p.pf_name 都道府県名,
 case 
   when cast(format("%.02f", round(inp_yes * 100.0) / (inp_yes + inp_no + UNIDENTIFIED)) as string) like '%.00'
            then cast(format("%d", round(inp_yes * 100.0) / (inp_yes + inp_no + UNIDENTIFIED)) as string)
   else  cast(format("%.02f", round(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