A somewhat related tip that works in SqlServer (not sure about other dialects) is to put the column alias first rather than at the end of a calculated column. E.g. rather than:<p><pre><code>  SELECT
    Foo,
    Sum(Baz) AS Bar
  FROM Quux
</code></pre>
Use instead:<p><pre><code>  SELECT
    Foo,
    Bar = Sum(Baz)
  FROM Quux
</code></pre>
The advantage here is that the names also line up neatly and the shape (column names etc.) of the result is obvious.