Querying two annotated fields at the same time return incorrect results

[pfcodes]

Describe the Bug

When I query two different annotated fields at the same time, the results are inaccurate.

@strawberry_django.interface(PersonModel)
class Person(Node):
        parked_cars: int = strawberry_django.field(
            annotate=Count(
                "cars",
                filter=Q(cars__status="parked"),
            )
        )
    parked_trucks: int = strawberry_django.field(
        annotate=Count(
            "trucks",
            filter=Q(trucks__status="parked"),
        )
    )

{
  person(id: "personId") {
    parkedCars     # this will return the correct value
    # parkedTrucks  -- this is commented out
  }
}

{
  person(id: "personId") {
    parkedCars   # this will return an incorrect value
    parkedTrucks  # now that this is no longer commented out, parkedCars returns an incorrect value, the value of this field is also incorrect
  }
}

System Information

• Strawberry version (if applicable): 0.47.0

Additional Context

Upvote & Fund

• We're using Polar.sh so you can upvote and help fund this issue.
• We receive the funding once the issue is completed & confirmed by you.
• Thank you in advance for helping prioritize & fund our backlog.

[pfcodes]

This isn't a strawberry issue, the problem here was that distinct=True needed to be set. Might be a good thing to add to the docs.