title: Create new table based on max count per id
body: <p>I have a table that looks like this:</p>
  
  <pre><code>ID  Code    Count
  A     AA    10
  A     BB    7
  B     AA    7
  B     BB    10
  C     CC    10
  C     DD    7
  </code></pre>
  
  <p>I was wondering how I could select each id with the highest count?</p>
  
  <p>I tried using this code as a reference, but am having no luck: <a href="https://stackoverflow.com/questions/2436820/can-i-do-a-maxcount-in-sql">Can I do a max(count(*)) in SQL?</a></p>