UPDATE emp e
   SET sal = (SELECT AVG(sal) * 1.2
                FROM bonus b
               WHERE b.ename = e.ename
 )
 WHERE deptno IN (SELECT deptno
                    FROM dept
                   WHERE loc = 'BOSTON')