title: Having and Where
body: <p>We use <code>HAVING</code> for groups of rows and <code>WHERE</code> for individual rows.<br>
  But the following is valid:  </p>
  
  <pre><code>SELECT Salesperson, SUM(TotalSale)  
     FROM SALES  
     GROUP BY Salesperson  
     HAVING Salesperson &lt;&gt; 'Georgio';    
  </code></pre>
  
  <p>I.e. use <code>HAVING</code> without an aggregate function. So couldn't we have also used <code>WHERE Salesperson &lt;&gt; 'Georgio';</code> instead?    </p>