title: SQL Query of Using Functions - How to get MAXIMUM Count of the list
body: <p>How can I query for the MAXIMUM COUNT Number of transaction...
  My code is as follows:</p>
  
  <pre><code>SELECT customer_id, COUNT(customer_id)
  FROM rental
  GROUP BY customer_id
  HAVING MAX(COUNT(customer_id)); //I need to get the MAXIMUM COUNT of the list
  </code></pre>