Question

Write the sql code that will change the proj_num to 14 for those employees who were hired before january 1, 1994 and whose job code is at least

Answer 1

update employees set proj_num = 14 where hire_date <= ‘19940101’