title: Incorrect syntax near the keyword 'where'. cant understand this error
body: <pre><code>select SNo 
  from Supplier  
  Having AVG(Qty) IN (
      Select SNo, AVG(Qty)AS Average 
      from Supplier 
      Group By SNo 
  )
  where (Qty) &gt;50 AND (Qty) &lt;100;
  </code></pre>