
update emp_copy set bonus = salary * 
   (case when salary < 5000 then 0.2
         when salary < 10000 then 0.1 
         else 0
    end)