title: MSSQL order by previous 7 days
body: <p>I run this query in MSSQL to get the items, grouping by the last 7 days of the week:</p>
  
  <pre><code>SELECT COUNT(Date_Entered), DATENAME(WEEKDAY, Date_Entered)  
      FROM my_table
      WHERE Board_Name = 'Board'
        AND DATEDIFF(DAY,Date_Entered,GETDATE()) &lt;= 7
    GROUP BY DATENAME(WEEKDAY, Date_Entered)
  </code></pre>
  
  <p>In the result, days of the week are sorted in alphabetical order: Friday > Monday > Saturday > Sunday > Thursday > Tuesday > Wednesday</p>
  
  <p>How do I sort by the normal/correct/common sense order, starting with the weekday of 7 days ago and ending with yesterday?</p>