title: SQL group by count where count greater than
body: <p>I have this SQL that counts the groups, but I want to say where the count is greater than 1, can anyone help as it doesn't currently work?</p>
  
  <pre><code>select Code, Qty, Count(Qty) from Product where ItemName = 'Banana'
  and Count(Qty) &gt; 1
  Group by Code, Qty order by 3 desc
  </code></pre>