title: What does the having count(*) > 1 refer to in this query?
body: <p>I've been trying to learn SQL by working through the book 'SQL Practice Problems' by Sylvia Moestl Vasilik, and wanted to make sure I understood what this specific query was doing:</p>
  <p>The question is: “Janet Leverling, one of the salespeople, has come to you with a request. She thinks that she accidentally double-entered a line item on an order, with a different ProductID, but the same quantity. She remembers that the quantity was 60 or more. Show all the OrderIDs with line items that match this, in order of OrderID”</p>
  <p>Here's a link to the OrderDetails table: <a href="https://dbfiddle.uk/?rdbms=sqlserver_2019&amp;fiddle=33b578a3edd85c7a1bb09d593e1330bc" rel="nofollow noreferrer">https://dbfiddle.uk/?rdbms=sqlserver_2019&amp;fiddle=33b578a3edd85c7a1bb09d593e1330bc</a></p>
  <p>The answer given in the book is</p>
  <pre><code>SELECT
      OrderID
  FROM
      OrderDetails
  WHERE 
      Quantity &gt;= 60
  GROUP BY
      Quantity, orderid
  HAVING
      COUNT(*) &gt; 1
  </code></pre>
  <p>Does this query just output instances where both quantity and orderid are repeated?</p>
  <p>Thanks and sorry if I posted this question in a stupid way.</p>