title: Postgres Counts based on Month and Years
body: <p>I have a psql table</p>
  
  <pre><code>Points
  id (SERIAL) | user(INTEGER) | time_of_point(TIMESTAMP) | title (TEXT)
  </code></pre>
  
  <p>I want to get a break down of users points that shows their points the current month, current year, and the lifetime.</p>
  
  <p>I'm a bit lost on how to do this. What would the query look like?</p>
  
  <p>The final table should look like this</p>
  
  <pre><code>User | Points (this month) | Points (this year) | Lifetime Points
  1    |     5               |     10             |     216
  2    |     7               |     14             |     125
  3    |    15               |    140             |     325
  </code></pre>