2
DROP SCHEMA IF EXISTS HU;
8
(EMPNUM CHAR(3) NOT NULL UNIQUE,
14
(PNUM CHAR(3) NOT NULL UNIQUE,
20
INSERT INTO STAFF VALUES ('E1','Alice',12,'Deale');
21
INSERT INTO STAFF VALUES ('E2','Betty',10,'Vienna');
22
INSERT INTO STAFF VALUES ('E3','Carmen',13,'Vienna');
23
INSERT INTO STAFF VALUES ('E4','Don',12,'Deale');
24
INSERT INTO STAFF VALUES ('E5','Ed',13,'Akron');
26
INSERT INTO PROJ VALUES ('P1','MXSS','Design',10000,'Deale');
27
INSERT INTO PROJ VALUES ('P2','CALM','Code',30000,'Vienna');
28
INSERT INTO PROJ VALUES ('P3','SDP','Test',30000,'Tampa');
29
INSERT INTO PROJ VALUES ('P4','SDP','Design',20000,'Deale');
30
INSERT INTO PROJ VALUES ('P5','IRM','Test',10000,'Vienna');
31
INSERT INTO PROJ VALUES ('P6','PAYR','Design',50000,'Deale');
33
SELECT EMPNUM, GRADE*1000
34
FROM HU.STAFF WHERE GRADE * 1000 >
35
ANY (SELECT SUM(BUDGET) FROM HU.PROJ
37
HAVING HU.PROJ.CITY = HU.STAFF.CITY);
41
DROP SCHEMA IF EXISTS HU;
47
(EMPNUM CHAR(3) NOT NULL UNIQUE,
53
(PNUM CHAR(3) NOT NULL UNIQUE,
59
INSERT INTO STAFF VALUES ('E1','Alice',12,'Deale');
60
INSERT INTO STAFF VALUES ('E2','Betty',10,'Vienna');
61
INSERT INTO STAFF VALUES ('E3','Carmen',13,'Vienna');
62
INSERT INTO STAFF VALUES ('E4','Don',12,'Deale');
63
INSERT INTO STAFF VALUES ('E5','Ed',13,'Akron');
65
INSERT INTO PROJ VALUES ('P1','MXSS','Design',10000,'Deale');
66
INSERT INTO PROJ VALUES ('P2','CALM','Code',30000,'Vienna');
67
INSERT INTO PROJ VALUES ('P3','SDP','Test',30000,'Tampa');
68
INSERT INTO PROJ VALUES ('P4','SDP','Design',20000,'Deale');
69
INSERT INTO PROJ VALUES ('P5','IRM','Test',10000,'Vienna');
70
INSERT INTO PROJ VALUES ('P6','PAYR','Design',50000,'Deale');
72
SELECT EMPNUM, GRADE*1000
73
FROM HU.STAFF WHERE GRADE * 1000 >
74
ANY (SELECT SUM(BUDGET) FROM HU.PROJ
76
HAVING HU.PROJ.CITY = HU.STAFF.CITY);