A left join combined with group by combined with sum

complexLINQquerySyntax.cs

public async Task<List<Result>> GetDistributionEvolution(List<Guid> listOfElements, int status)
{
    var results = await (from firsts in _dbContext.FirstList
                              join seconds in _dbContext.SecondList on firsts.Id equals seconds.ForeginKey
                              into scs
                              from scsResult in scs.DefaultIfEmpty()
                              where scsResult.StatusId == stateId &&
                                  listOfElements.Contains(scsResult.ElementKey)
                              group scsResult by firsts.Year into yearGroup
                              select new Result
                              {
                                  Year = yearGroup.Key,
                                  Amounts = yearGroup.Sum(g => g.GrossAmount)
                              }).ToListAsync();

    return results;
}