SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Person ( PersonID INTEGER, Name VARCHAR(32), Jahre INTEGER, EMail VARCHAR(64), PRIMARY KEY (PersonID) ); INSERT INTO Person VALUES ( '10000', 'Schneider', '5', 'Schneider@Köln' ); INSERT INTO Person VALUES ( '10001', 'Müller', '30', 'Müller@Köln' ); INSERT INTO Person VALUES ( '10002', 'Schmidt', '36', 'Schmidt@Köln' ); INSERT INTO Person VALUES ( '10003', 'Stratmann', '36', 'Stratmann@Köln' ); CREATE TABLE Buch ( ISBN VARCHAR(13), Autor INTEGER, Titel VARCHAR(64), Seiten INTEGER, PRIMARY KEY (ISBN) ); INSERT INTO Buch VALUES ( 'etztZTzhjiuz6', '10003', 'Kölner jungs', '36' ); INSERT INTO Buch VALUES ( 'et6h78zhjiuz6', '10002', 'Nice', '136' ); INSERT INTO Buch VALUES ( 'et6h78zhjjuz6', '10002', 'Nice 2', '14' ); CREATE TABLE Review ( PersonID INTEGER, ISBN VARCHAR(13), Inhalt TEXT, Sterne INTEGER, PRIMARY KEY (PersonID, ISBN) ); INSERT INTO Review VALUES ( '10002', 'etztZTzhjiuz6', 'Kölner jungs war gut', '5' ); SELECT * FROM Person WHERE Jahre <> 30; SELECT DISTINCT Name FROM Person WHERE Name NOT LIKE '_t%'; (SELECT EMail FROM Person, Buch WHERE Autor = PersonID) UNION (SELECT EMail FROM Person WHERE PersonID NOT IN (SELECT PersonID FROM Review)); SELECT Autor, SUM(Seiten) FROM Buch GROUP BY Autor HAVING MIN(Seiten) >= 100;