SQLize Online / PHPize Online  /  SQLtest Online

create table Person ( UserID int primary key, Name text , Status text, Punkte int); create table Buch ( BuchID int primary key, Autor int references Person, Verlag text, Seiten int); create table Review( UserID int references Person, BuchID int references Buch, Datum date, Inhalt text, primary key(UserID, BuchID, Datum)); insert into Person values ( 3, "anna", "tot", 30); select sum(UserID), UserID from Person having sum(UserID) >1;