Number of submitted results and averages per event, e.g.
SELECT *
FROM Results
WHERE eventId = "444bf" and average > 0
GROUP BY personId
Interestingly enough the MySQL database query site will take this but SELECT * ... GROUP BY isn't valid in SQL server, because it's not clear how the non-grouping columns get selected.
Number of submitted results and averages per event, e.g.
Interestingly enough the MySQL database query site will take this but
SELECT * ... GROUP BY
isn't valid in SQL server, because it's not clear how the non-grouping columns get selected.