title: How to convert this linq from query syntax to method syntax
body: <p>I was able to get this to work like I wanted it to, but I prefer the method syntax to the query syntax.</p>
  
  <p>How can this be written with method syntax?</p>
  
  <pre><code>var data = (from stat in this._applicationDbContext.Stats
              where stat.SupId == this.GetCurrentSupId() &amp;&amp; stat.StatType == 1
              orderby stat.WeekEnding descending
              group stat by stat.WeekEnding into statGroup
              select new WeeklyStat
                         {
                             WeekEnding = statGroup.First().WeekEnding,
                             Amount = statGroup.Sum(a =&gt; a.StatValue)
                         }).Take(6);
  </code></pre>
  
  <p>This is the original SQL:</p>
  
  <pre><code>SELECT TOP (6)  
      SUM([stat_value]) AS lessons_graded,
      CONVERT(DATE, [weekend]) weekending 
  FROM 
      [dbo].[Stats]
  WHERE
      stat_type = 1 AND sup_id = 1113
  GROUP BY
      CONVERT(DATE, [weekend])
  ORDER BY 
      CONVERT(DATE, [weekend]) DESC
  </code></pre>