select merid, vendername, shoppingmonth, totalordernumber, successordernumber, totalpayamount, successtotalpayamount, case totalordernumber when 0 then '0%' else convert(varchar,convert(decimal(10,2),convert(decimal(16,2), successordernumber)*1.0/convert(decimal(16,2), totalordernumber)*100 ))+'%' end as successratefrom vender vleft join gnete_mer_stat_months s on v.venderid = s.meridwhere shoppingmonth between 201403and 201406and v.deleted = 0group by merid, vendername, shoppingmonth, totalordernumber, successordernumber, totalpayamount, successtotalpayamountorder by merid asc, shoppingmonth asc