Part 3 of this Series introduces aggregation subquery promotion, a rewrite strategy for aggregation-related subqueries, and the pitfalls of this rewrite strategy.