title: Not a GROUP BY Expression, but why?
body: <p>I'm completely confused as to why this code is not a GROUP BY expression:</p>
  
  <pre><code>SELECT Section_ID, COUNT(Student_ID) 
  FROM Enrollment
  WHERE Enroll_Date = TO_DATE('22-FEB-2007', 'DD-MON-YYYY')
  GROUP BY Section_ID
  ORDER BY Section_ID DESC, Student_ID;
  </code></pre>
  
  <p>I know it has something to do with the COUNT function, but I can't figure out why. Even if I add COUNT(Student_ID) to the GROUP BY I get a different error saying group function isn't allowed here. What am I doing wrong?</p>