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