SELECT SPJ.SNO FROM SPJ,P WHERE SPJ.PNO IN
(SELECT SPJ.PNO FROM SPJ,S,P
WHERE S.SNO=SPJ.SNO AND P.PNO=SPJ.PNO AND P.COLOR=‘红’); 3.17
SELECT SPJ.JNO FROM S,P,SPJ
WHERE S.SNO=SPJ.SNO AND J.JNO=SPJ.JNO; 3.18
SELECT S.CITY,J.CITY FROM S,J,SPJ
WHERE S.SNO=SPJ.SNO AND J.JNO=SPJ.JNO; 3.19
SELECT S.CITY,SPJ.PNO,J.CITY FROM S,J,SPJ WHERE S ,=SPJ.SNO AND J.JNO =SPJ.JNO; 3.20
SELECT S.CITY,SPJ.PNO,J.CITY FROM SPJ,S,J WHERE S.SNO=SPJ.SNO AND J.JNO=SPJ.JNO AND S.CITY<>J.CITY; 3.21
SELECT JNO FROM SPJ AS SPJ1 WHERE NOT EXISTS(
SELECT 1 FROM SPJ AS SPJ2
WHERE SNO=‘S1’ AND NOT EXISTS
(SELECT 1 FROM SPJ AS SPJ3
WHERE SPJ3.PNO=SPJ2.PNO AND SPJ3.JNO=SPJ1.JNO)); 3.22
UPDATE P SET COLOR=‘红’ WHERE COLOR=‘橙’; 3.23
DELETE FROM SPJ,P
WHERE SPJ.PNO=P.PNO AND P.COLOR=‘红’;
DELETE FROM P WHERE COLOR=‘红’; 3.24
SELECT SPJ.SNO,SPJ,PNO,SUM(QTY) FROM SPJ WHERE SPJ.SNO=‘S1’ AND SPJ.PNO=‘P1’ GROUP BY SPJ.SNO,SPJ,PNO; 3.25
SELECT SPJ.SNO,COUNT(*) FROM SPJ GROUP BY SPJ.SNO; 3.26
SELECT JNO FROM SPJ GROUP BY SNO HAVING SUM(QTY)>1000;