title: Returning results based on last date in SQL
body: <p>I'm interested in retaining only individuals in a Microsoft SQL Server query that have a value over a certain threshold on two separate dates. If the individuals have a score higher than 150 twice, I would like to return their ID, the second date that their score was above 150, and the score on the second date. </p>
  
  <p>Here is the data:</p>
  
  <pre><code>SubjectID   DATE         Score
  001         01/11/2014   147
  001         02/11/2013   151
  002         02/10/2015   152
  003         08/12/2013   155
  002         01/31/2012   159
  003         07/19/2016   157
  </code></pre>
  
  <p>So I for the results, I would like to return the following:</p>
  
  <pre><code>SubjectID   DATE         Score
  002         02/10/2015   152
  003         07/19/2016   157
  </code></pre>