问如何将SQL查询转换为LINQ？

EN

from t in Temp_Nurse_Fill_RequestNumbers 
group by t.ShiftName, t.date
into g 
select new 
{
   Date = g.date,
   Score = (from tt in g select tt.Score).max
   IsPreferred = 1
};

temps
    .GroupBy(x => new {x.ShiftName, x.Date})
    .Select(g => new TempNurseProjection
        {
            Date = g.Key.Date,
            ShiftName = g.Key.ShiftName,
            MaxScore = g.Max(q => q.Score),
            IsPreferred = true
        });