title: Group By and Limiting the output in mySql
body: <p>I am having a difficult time with the syntax.  I know where the error is but cant get the line correct.</p>
  
  <p>Lets say in trying to count food groups and I want to see the detailed count of food groups.</p>
  
  <p>This works great:</p>
  
  <pre><code>SELECT FoodGroup, Count(*) as mycount
  FROM Food
  Group By FoodGroup
  </code></pre>
  
  <p>I get a nice output</p>
  
  <pre><code>Vegies 190
  Spices  64
  breads  16
  </code></pre>
  
  <p>But I wish to limit my output to those with 50 or more items </p>
  
  <pre><code>SELECT FoodGroup, Count(*) as mycount
  FROM Food
  Where mycount &gt; 49   &lt;--this line in the issue
  Group By FoodGroup
  </code></pre>
  
  <p>What should the WHERE clause Look Like?</p>