title: MySQL count how many records has user made
body: <p>I'm trying to count how many records has unique player [auth] made.
  So basically I'm trying to select lowest time on every map and count who has most entries left.</p>
  
  <p>I got this far with a lot of googling.</p>
  
  <pre><code>SELECT
      auth,
      map,
      MIN(time) AS Record
  FROM
      bhop.playertimes
  WHERE track LIKE '0'
  GROUP BY
      map
  )
  </code></pre>
  
  <p>This successfully lists every maps top time and [auth] who made the record.
  What would be easiest way to sum the [auth] entries?</p>
  
  <p>I would prefer this type answer query:</p>
  
  <p>[auth] [records_made]</p>
  
  <p><a href="https://i.stack.imgur.com/3Bug6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3Bug6.png" alt="Database structure"></a></p>
  
  <p><a href="https://i.stack.imgur.com/UfYcF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UfYcF.png" alt="Query result"></a></p>