title: MySQL Order by date with GROUP BY DATE FORMAT is alphabetical
body: <p>This is my query: </p>
  
  <pre><code>Select Date_format(`date`, '%b %Y') as 'Categories',
  ..... as 'a1',....... as 'a2'
  FROM table1
  GROUP BY Date_format(`date`, '%b %Y')
  ORDER BY Date_format(`date`, '%b %Y') ASC
  </code></pre>
  
  <p>Answer is alphabetical because, <code>date_format</code> convert date to string, I need sorting by date, but, group by is the problem. I need <code>group by</code> only for  <code>Date_format('date','%b %Y')</code></p>
  
  <p>Please give a solution </p>