title: How shall I write max, group by, where, order by in one sql statement?
body: <p>I need to find the customerID who launched the most orders in 1996. And I have written the following statement:</p>
  <pre><code>SELECT count(orderID) as orderNumber
       , CustomerID
       , OrderDate  
    FROM Orders 
   where OrderDate between &quot;1996-01-01&quot; AND &quot;1996-12-31&quot; 
   group 
      by CustomerID 
   order 
      by orderNumber DESC ;
  </code></pre>
  <p>And the result is below:
  <a href="https://i.stack.imgur.com/Y1BLm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y1BLm.png" alt="enter image description here" /></a></p>
  <p>My question is  I just want to print the top customerID which is 65,63,20, but I don't know how to write it.
  I think I shall use max here to filter the customerID who has launched 6 orders.
  Am I right?</p>