Exercise · SQL & Querying
Predict, then run it
Predict the output
waits(stop, mins) = (a,10),(a,10),(a,10),(b,40). The true overall average wait comes from the raw rows, not the stop averages:
SELECT ROUND(AVG(mins), 2) AS wait FROM waits;
Predict the exact output.