SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Roommates(gpa FLOAT, name TEXT, pid Int, PRIMARY KEY(pid)); INSERT INTO Roommates VALUES(4.07, 'Connor', 1); INSERT INTO Roommates VALUES(4.03, 'Peter', 2); INSERT INTO Roommates VALUES(4.01, 'Alex', 3); INSERT INTO Roommates VALUES(3.88, 'Darby', 4); CREATE TABLE Friends(age INT, fname TEXT, fid Int, PRIMARY KEY(fid)); INSERT INTO Friends(fname, fid) VALUES('Thomas', 1); INSERT INTO Friends(fname, fid) VALUES('Elita', 2); CREATE TABLE Friendships(pid Int, fid Int, Primary Key(pid, fid)); ALTER TABLE Friendships ADD FOREIGN KEY(pid) REFERENCES Roommates(pid); ALTER TABLE Friendships ADD FOREIGN KEY(fid) REFERENCES Friends(fid); INSERT INTO Friendships VALUES(1, 1); INSERT INTO Friendships VALUES(1, 2); INSERT INTO Friendships VALUES(3, 1); INSERT INTO Friendships VALUES (4, 2); SELECT * FROM Roommates JOIN Friendships ON (Roommates.pid = Friendships.pid) JOIN Friends ON (Friendships.fid = Friends.Fid) WHERE Friends.fname = 'Thomas' OR Friends.fname = 'Elita' -- SELECT * FROM Roommates; -- -- SELECT * FROM Friendships; --