title: How to SELECT sum of numbers less than 30 and sum of numbers greater than 30?
body: <p>I'm trying to write a SELECT statement to select the sum of field but I want to return the sum of numbers less than 30 and also the sum of numbers greater than 30. I realize I can do this with two selects joined together, but I was hoping to find a "neat" way of doing it.</p>