14. The non-transitory computer-readable storage medium of claim 12 , wherein: the GROUP BY clause in the outer query is a first GROUP BY clause that references one or more columns; the subquery includes a second GROUP BY clause that references one or more columns; the one or more columns referenced in the first GROUP BY clause includes the one or more columns referenced in the second GROUP BY clause; and instructions for generating the transformed query further comprises instructions for: creating a second inline view; wherein: the inline view is a first inline view; the first inline view is nested within the second inline view; the algebraic aggregate window function includes a partition-by clause that references the one or more columns references in the second GROUP BY clause; and the predicate in the outer query that references the first inline view also references the second inline view.
14. The non-transitory computer-readable storage medium of claim 12 , wherein: the GROUP BY clause in the outer query is a first GROUP BY clause that references one or more columns; the subquery includes a second GROUP BY clause that references one or more columns; the one or more columns referenced in the first GROUP BY clause includes the one or more columns referenced in the second GROUP BY clause; and instructions for generating the transformed query further comprises instructions for: creating a second inline view; wherein: the inline view is a first inline view; the first inline view is nested within the second inline view; the algebraic aggregate window function includes a partition-by clause that references the one or more columns references in the second GROUP BY clause; and the predicate in the outer query that references the first inline view also references the second inline view. 15. The non-transitory computer-readable storage medium of claim 14 , wherein: the HAVING clause specifies that an ANY function be applied to the subquery; the second inline view includes a MIN function that references the algebraic aggregate window function; and the predicate in the outer query references an output of the MIN function.