Query stages and local ranking
Order filtering, aggregation, history and quotas at their correct scope.
Why does filtering large rows produce the wrong total-qualified groups?
Apply the threshold after signed group totals are formed.
Why does a sorted shortlist omit the highest-priority record?
Sort the full candidate set before choosing its top two.
Why does a flagged sample lose its actual previous reading?
Calculate LAG on the full history before filtering displayed rows.
Why does a two-per-queue shortlist contain only one queue?
Apply a strict local quota with partitioned ranking.
Why does ordering report rows leave a concatenated workflow out of order?
Order aggregate inputs separately from output groups.