title: any suggestions on how to overcome ORA-00937?
body: <pre><code>select s.S_FIRST||' '||s.S_LAST, sum(c.CREDITS) from enrollment e,student s,course c
  where s.s_id=e.S_ID
  and c.COURSE_NO=e.C_SEC_ID
  group by s.S_ID
  having sum(c.credits)&gt;12 order by s.s_id;
  
  Error report:
  SQL Error: ORA-00979: not a GROUP BY expression
  00979. 00000 -  "not a GROUP BY expression"
  </code></pre>
  
  <p>It keeps coming back with an error, any suggestions ?</p>
  
  <p>thanks for your cooperation </p>