title: Count unique values of actual year (not present in previous years)
body: <p>I am new to SQL and I was hoping you can help me with a question. I have a table from which I need to count unique values of this year, if they do not exist in years before (Basically I want to know only new entries for 2016).</p>
  
  <pre><code>BP Name       Year
  A             2013
  B             2016
  A             2014
  A             2016
  C             2012
  C             2016
  </code></pre>
  
  <p>In this case it would count only as 1 (BP Name: B)</p>
  
  <p>Thanks
  Kastriot</p>