title: MySQL Get last date in each month from column of dates
body: <p>An example is shown below; imagine each commar separated date is a row in the database</p>
  
  <p>Input: - 2010-01-11, 2010-01-18, 2010-01-25, 2010-02-01, 2010-02-08, 2010-02-15, 2010-02-22, 2010-03-01 it should return</p>
  
  <p>Ouput: 2010-01-25, 2010-02-22, 2010-03-01</p>
  
  <p>The output is derived by getting the last date in the month, note for March there is only one date in the database so we use that value.</p>
  
  <p>I would appreciate it if someone could post some pseudo-SQL about how to approach this problem. Note, I am using My-SQL so those date functions are available. </p>
  
  <p>Cheers,</p>