d
b
a
c
select name , replace(job, 'Programmer', 'Analyst/Programmer') from employee;
insert into department values (NULL, 'Property Services'); insert into employee values (NULL, 'Fred Smith', 'DBA', last_insert_id());
select max(workdate) from assignment;