Exercise · SQL & Querying
Predict, then run it
Predict the output
runs(t) = 10, NULL, 20 (the NULL is a DNF). The average per entrant counts every row, DNFs included:
SELECT SUM(t) * 1.0 / COUNT(*) AS per_entrant FROM runs;
Predict the exact output.