title: Getting all entries less than max price and more than one entry from having
body: <p>I'm using the Northwind database from W3 schools and my query is</p>
  <pre><code>SELECT Price from products group by Price having Price &lt; max(Price)
  </code></pre>
  <p>It's currently showing no results, but how would I fix that? You can see the database here: <a href="https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_having" rel="nofollow noreferrer">https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_having</a></p>
  <p>Additionally, is it possible to get more than one entry returned from having, i.e, all rows that meet the having clause condition. For example, in the link above, only unique countries are returned that meet the condition.</p>
  <p>EDIT: Also with the Northwind database:</p>
  <pre><code>SELECT *FROM Customers GROUP BY City HAVING COUNT(City) &gt; 2;
  </code></pre>
  <p>Why does it have unexpected behaviour, i.e, not return the rows where there are more than two occurrences of the city.</p>