title: How to use group by
body: <p>I have a group by problem with oracle, I'm trying to group together all wards which have service charges over £2500. I have two tables Ward and Bed, wardno is in both tables. Here is what I have and the error I keep getting:</p>
  
  <pre><code>SELECT HospitalCode, Ward.WardNo, Bed.WardNo, BedNo, TotalServiceCosts,  
  FROM WARD, BED  
  GROUP BY TotalServiceCosts &gt;= 2500  
  
  ORA-00936: missing expression
  </code></pre>
  
  <p>Can someone help me with the missing expression?</p>