SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE R(X INT, Y INT); CREATE TABLE S(Y INT, Z INT); CREATE TABLE T(Z INT, Y INT); CREATE TABLE TT(Z INT, Y INT); INSERT INTO R(X,Y) VALUES (1,1),(2,2),(3,3),(4,3),(5,5); INSERT INTO S(Y,Z) VALUES (1,1),(2,1),(3,4),(3,5),(5,6); INSERT INTO T(Z,Y) VALUES (1,1),(1,2),(4,3),(5,3),(6,5); INSERT INTO TT(Z,Y) VALUES (1,1),(1,2),(4,3),(5,3),(6,5); CREATE VIEW ANSWERS(X,Y,Z) AS SELECT DISTINCT R.X, R.Y, S.Z FROM R JOIN S ON S.Y=R.Y JOIN T ON T.Z=S.Z JOIN TT ON TT.Z=S.Z; CREATE VIEW SIMPLE(X1,X2) AS SELECT DISTINCT R1.X AS X1, R2.X AS X2 FROM ANSWERS AS R1 JOIN ANSWERS AS R2 ON (R1.X!=R2.X) AND (R1.X!=R2.X OR R1.Y=R2.Y) AND (R1.Y!=R2.Y OR R1.Z=R2.Z) AND (R1.Z!=R2.Z OR R1.Y=R2.Y); CREATE VIEW CONFLICTIVE(X1,X2) AS SELECT R1.X AS X1, R2.X AS X2 FROM ANSWERS AS R1 JOIN ANSWERS AS R2 ON (R1.X!=R2.X) AND NOT EXISTS(SELECT * FROM SIMPLE WHERE SIMPLE.X1=R1.X AND SIMPLE.X2=R2.X); SELECT * FROM ANSWERS; SELECT * FROM SIMPLE; SELECT * FROM CONFLICTIVE;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear