title: With a GROUP BY select, can you sort by the projection's SUM?
body: <p>I have a SELECT that uses GROUP BY X. It uses SUM in the projection.  Is there any way to sort on that SUM?  The group result with the highest value should be first in results table.  I suspect there is no way to sort on this SUM since as each group is completed it's output and gone; there isn't any "collection" to sort.  There is something totally different I have to do here.  Do you have any hints?</p>
  
  <p>Thank you.</p>
  
  <p>(beginner)</p>