Re: Why subquery?

[Alexander Keremidarski]

Aggregate functions can be sued in expressions in SELECT part so the following one is legal SQL:

SELECT c, MIN(i) - MAX(i) AS min_minus_max FROM foo GROUP BY c;