NULL & three-valued logic
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.