title: sql select where (sum of 2 columns) is greater than X
body: <p>I have a dynamic SQL query based on user selections.  2 of the columns (FullBath, HalfBath) need to be counted as one for SELECT operations.  EX: a user searches for a property in a specific town and minimum number of bathrooms (HalfBath and FullBath combined) is greater than or equal to x.</p>
  
  <p>I tried variations of:</p>
  
  <p>SELECT * From Rentals WHERE Town = <i>town</i> AND (SUM(FullBath + HalfBath) >= <i>bathrooms</i>)</p>
  
  <p>=========================</p>
  
  <p>I found answer (don't need SUM...) </p>