nkRtt77f

1drop table if exists emp_1;
2-- 1
3CREATE TABLE EMP_1(
4			EMP_NUM VARCHAR(3),
5            EMP_LNAME VARCHAR(15) NOT NULL,
6            EMP_FNAME VARCHAR(15) NOT NULL,
7            EMP_INITIAL CHAR(1),
8            EMP_HIREDATE DATE,
9            JOB_CODE VARCHAR(3),
10            PRIMARY KEY (EMP_NUM),
11            foreign key (JOB_CODE) REFERENCES JOB(JOB_CODE));
12            
13-- 4
14commit;
15
16-- 7
17CREATE TABLE EMP_2 LIKE EMP_1;
18INSERT EMP_2 SELECT * FROM EMP_1;
19
20-- 8
21ALTER TABLE EMP_2 ADD EMP_PCT DECIMAL(4,2);
22ALTER TABLE EMP_2 ADD PROJ_NUM CHAR(3);
23
24-- 10
25UPDATE EMP_2 SET EMP_PCT = 5.00 WHERE EMP_NUM = 101 OR EMP_NUM = 105 OR EMP_NUM = 107;
26
27-- 13 
28UPDATE EMP_2 SET PROJ_NUM = 18 WHERE JOB_CODE = 500;
29
30-- 14
31UPDATE EMP_2 SET PROJ_NUM = 25 WHERE JOB_CODE >= 502;
32
33-- 15
34UPDATE EMP_2 SET PROJ_NUM = 14 WHERE JOB_CODE >= 501 and EMP_HIREDATE < '1994-01-01';
35