问Mysql到Linq查询

EN

select MAX(os.aggregate_date) as lastMonthDay,os.totalYTD
  from (SELECT aggregate_date,Sum(YTD) AS totalYTD 
        FROM tbl_aggregated_tables
          WHERE subscription_type = 'Subcription Income'
        GROUP BY aggregate_date) as os
GROUP by MONTH(os.aggregate_date),YEAR(os.aggregate_date)
ORDER BY lastMonthDay;

var income = context.tbl_aggregated_tables
                   .Where(s => s.subscription_type == "Subcription Income")
                   .GroupBy(s => s.aggregate_date)
                   .Select(result => new
                   {
                       date = result.Key,
                       ytdsum = result.Select(x => x.YTD).Sum()
                   })
                   .GroupBy(s => new { month = s.date.Month, year = s.date.Year })
                   .Select(
                    // select max data and take its ytdsum value 
                        ).ToList();

income = context.tbl_aggregated_tables
                   .Where(s => s.subscription_type == "Subcription Income")
                   .GroupBy(s => s.aggregate_date)
                   .Select(result => new
                   {
                       date = result.Key,
                       ytdsum = result.Select(x => x.YTD).Sum()
                   })
                   .GroupBy(s => new { s.date.Month, s.date.Year })
                   .Select(
                     x => x.Max(s => s.date)
                   ).ToList()