I have a .NET Core 3.1 project with EF Core 3.1.8. Lets say I have two entitys:

```here
public class Card
{
    public int CardId { get; set; }
    public int Stage { get; set; }
    public int SectionId { get; set; }
    public Section Section { get; set; }        
}

public class Section
{
    public int SectionId { get; set; }
    public string Title { get; set; }
    public List<Card> Cards { get; set; }
}

```

Now I want a query that gives me the sections and for each section the information of how many Cards with Stage=1, Stage=2, Stage=3 etc. are in there.

I tried this:

```
var q = _dbContext.Sections
              .Include(s => s.Cards)
              .Select(s => new
              {
                  s.SectionId,
                  cards = s.Cards
                           .Select(c => c.Stage)
                           .GroupBy(c => c)
                           .Select(c => new { c.Key, count = c.Count() })
              })
              .ToList();

```

But in the result is always only one section with only one card. How can I do this?