-
Jonie Weber just got married to Bob Williams. She has requested that her last name be updated to Weber-Williams.
update
myemployees_ts0211
set lastname=
'Weber-Williams'
where firstname=
'Jonie'
and lastname=
'Weber';
-
Dirk Smith's birthday is today, add 1 to his age.
update myemployees_ts0211
set age=age+1
where firstname='Dirk' and lastname='Smith';
-
All secretaries are now called "Administrative Assistant". Update all titles accordingly.
update myemployees_ts0211
set title = 'Administrative Assistant'
where title = 'Secretary';
-
Everyone that's making under 30000 are to receive a 3500 a year raise.
update myemployees_ts0211
set salary = salary + 3500
where salary < 30000;
-
Everyone that's making over 33500 are to receive a 4500 a year raise.
update myemployees_ts0211
set salary = salary + 4500
where salary > 33500;
-
All "Programmer II" titles are now promoted to "Programmer III".
update myemployees_ts0211
set title = 'Programmer III'
where title = 'Programmer II'
-
All "Programmer" titles are now promoted to "Programmer II".
update myemployees_ts0211
set title = 'Programmer II'
where title = 'Programmer'