title: Mysql group rows by date into 4 seasons + year
body: <p>At the moment I am grouping the news into month+year but we dont have enough news articles. So instead would like to group them by season: summer, spring, autumn or winter + year</p>
  
  <p>So instead of:</p>
  
  <ul>
  <li>January 2013 </li>
  <li>March 2013 </li>
  <li>April 2013</li>
  </ul>
  
  <p>It would be:</p>
  
  <ul>
  <li>Summer 2013 </li>
  <li>Spring 2013</li>
  </ul>
  
  <p>Monthly archieve</p>
  
  <pre><code>SELECT MONTHNAME(news_date) AS MONTH,
         YEAR(news_date) AS YEAR,
         COUNT(news_id) AS COUNT
  FROM news
  WHERE news_type = 'NEWS'
    AND news_status = 'ENABLED'
  GROUP BY CONCAT(MONTH(news_date), ' ', YEAR(news_date))
  ORDER BY news_date DESC
  </code></pre>