title: How to write Stored procedure to get the group data of a month and year
body: <p>How to Create stored proc  that gives totals grouped for month and  year</p>
  
  <p>sale tablename</p>
  
  <pre><code>year week  date      value
  2008 4    2008-01-21  50
  2008 5    2008-02-22  25
  2008 6    2008-02-23  30
  </code></pre>