UPDATE employees
SET salary = salary * 2 
        WHERE EXISTS   (SELECT e.first_name, sum (amount) as total_amt, YEAR (CAST (sales_time AS DATE)) AS SALES_DATE
						FROM sales s join employees e on s.employee_id = e.id
						GROUP BY e.first_name, YEAR(CAST(sales_time AS DATE))
						having  YEAR(CAST(sales_time AS DATE)) = 2017
						AND sum (amount) > 10000)	

UPDATE employees
SET salary = 
       CASE
	   WHEN   EXISTS   (SELECT e.first_name, sum (amount) as total_amt, YEAR (CAST (sales_time AS DATE)) AS SALES_DATE
						FROM sales s join employees e on s.employee_id = e.id
						GROUP BY e.first_name, YEAR(CAST(sales_time AS DATE))
						having  YEAR(CAST(sales_time AS DATE)) = 2017
						AND sum (amount) > 10000)	

						THEN salary * 2 
		                END