title: How to query specific values in sequel pro?
body: <p>I'm using sequel pro to run some queries on a large database that I have. I am quite new to this so please excuse if my question is stupid or obvious.</p>
  
  <p>I have data from app users who have played a specific game (which in our database has value 32. They can play a number of times. I select COUNT(gamescore.Score) to find the number of times they played the game and a new score will be recorded for each time they play. Now I want to know what their 3rd game score in time was, if they played multiple times. </p>
  
  <p>I have attached an image for better explanation. The person with UserID 18211 has played game "32" a number of times and their scores are shown in the first column. I want to know what is the score when they played the game for the third time. So by looking at the table, I know that this score is 109 the third time they played which was on 2016-09-09. But I have to do this for many users so I can't look at them all manually. </p>
  
  <p>Here is the code:</p>
  
  <pre><code>SELECT DISTINCT gamescore.UserID, COUNT(gamescore.Score), gamescore.GameId
  FROM gamescore
  WHERE gamescore.GameID = "32"
  GROUP BY gamescore.UserID
  </code></pre>
  
  <p>I'm unsure of how to modify the query to get score of the 3rd time they played...  Can anyone help? </p>
  
  <p>Sample data: <a href="https://i.stack.imgur.com/V6Z0Q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V6Z0Q.png" alt="enter image description here"></a></p>
  
  <p>Thanks</p>