Aggregation & GROUP BY
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.