Comment by eterm

Max on submission date doesn't return the corresponding order ID from that row, aggregations are applied separately.

That's a classic pitfall that comes up all the time.