Flamefever · · SQL
SELECT PA.PID, PA.pname, MAX(PL.score), AVG(PL.score) FROM participant PA, played PL WHERE PL.pid = PA.pid AND (SELECT * FROM played pl2 WHERE count(pl2.pid) > 1) SELECT pl.PID, FROM played pl WHERE pl.pid = pl2.pid and (SELECT pl2.PID, count(pl2.GID) FROM played pl2) SELECT pl.PID FROM played pl WHERE pl.pid = pl2.pid and (SELECT pl2.PID, MAX(count(pl2.GID)) FROM played pl2)
Click on the Run button to get started.
The code/input has changed since you last clicked on Run. Click it again to see the updated changes.