- update employee
set city = ’Newton’ where
person-name = ’Jones’
- update works
set salary = salary * 1.1
where company-name = ’First Bank Corporation’
- update works
set salary = salary * 1.1
where employee-name in (select manager-name from manages)
and company-name = ’First Bank Corporation’
- update works T set T.salary = T.salary * 1.03
where T.employee-name in (select manager-name from manages)
and T.salary * 1.1 > 100000 and T.company-name = ’First Bank Corporation’
update works T set T.salary = T.salary * 1.1
where T.employee-name in (select manager-name from manages)
and T.salary * 1.1 <= 100000 and T.company-name = ’First Bank Corporation’
- delete works
where company-name = ’Small Bank Corporation’