title: Group By with syntax error
body: <p>This shows up as NULL.</p>
  
  <pre><code>SELECT Gender, SUM( DISTINCT Freq ) AS TotalApp, 
  (
      SELECT SUM( Freq ) 
      FROM ucbadmissions
      WHERE Admit = 'Rejected'
      IN (
          SELECT Admit
          FROM ucbadmissions
         )
  ) AS AdmRate
  FROM ucbadmissions
  GROUP BY Gender
  </code></pre>
  
  <p>This shows as the error.</p>
  
  <pre><code>SELECT Gender, SUM( DISTINCT Freq ) AS TotalApp, 
  (
      SELECT  SUM( Freq ) 
      FROM ucbadmissions
      WHERE Admit != 'Rejected'
      Group By Gender
  ) AS AdmRate
  FROM ucbadmissions
  Group By Gender
  </code></pre>
  
  <p>Example of the table.</p>
  
  <blockquote>
    <p>Admit    Gender  Dept  Freq<br>
    Admitted Male     A 512 <br>
    Rejected Male     A 313 <br>
    Admitted Female   A 89 <br>
    Rejected Female   A 19 <br>
    Rejected Female   B 8 <br>
    Admitted Female   B 17 <br>
    Rejected Male     B 207 <br>
    Admitted Male     B 353 <br></p>
  </blockquote>