title: sorting month in ascending order
body: <p><em>I have looked at related Qs on Stack</em>.
  I am trying to sort my query to display month in ascending order. A similar post on Stack said that I must indicate "ASC", but this doesn't work for me. I have written an Order By. I cannot figure out why it is not working. </p>
  
  <pre><code>SELECT  DATENAME( MONTH,(Submission.SubmissionDate)) AS [Date]        
  FROM Submission 
  GROUP BY DATENAME( MONTH,(Submission.SubmissionDate)) ORDER BY [Date] ASC;
  </code></pre>
  
  <p>This is the output:  </p>
  
  <pre><code>  Month
    August
   February
   September
  </code></pre>
  
  <p>Note: this is just a part of my query, I didnt think it would necessary to show the rest, which relates to other attributes from my table (Not month related)</p>
  
  <p>Edit: This is my Entire Query: (The Initial One)</p>
  
  <pre><code>SELECT  DATENAME( MONTH,(Submission.SubmissionDate)) AS [Date], 
  SUM( CASE WHEN Submission.Status='Under review' THEN 1 ELSE 0 END) [Under_Review], 
  SUM( CASE WHEN Submission.Status='Accepted' THEN 1 ELSE 0 END) [Accepted], 
  SUM( CASE WHEN Submission.Status='Rejected' THEN 1 ELSE 0 END) [Rejected], 
  SUM( CASE WHEN Submission.Status='In print' THEN 1 ELSE 0 END) [In_print], 
  SUM( CASE WHEN Submission.Status='Published' THEN 1 ELSE 0 END) [Published] 
  FROM Submission INNER JOIN ((Faculty INNER JOIN School ON Faculty.FacultyID = School.[FacultyID]) INNER JOIN (Researcher INNER JOIN ResearcherSubmission ON Researcher.ResearcherID = ResearcherSubmission.ResearcherID) ON School.SchoolID = Researcher.SchoolID) ON Submission.SubmissionID = ResearcherSubmission.SubmissionID 
  GROUP BY DATENAME( MONTH,(Submission.SubmissionDate)) 
  ORDER BY DATENAME( MONTH,(Submission.SubmissionDate));
  </code></pre>