django queryset group by count

from django.db.models import Count
from yourapp.models import YourModel

# Step 1: Define a queryset using Django's ORM
queryset = YourModel.objects.values('your_field')

# Step 2: Use annotate() to add a count aggregation to the queryset
queryset = queryset.annotate(count=Count('your_field'))

# Step 3: Use values() to select specific fields in the queryset
queryset = queryset.values('your_field', 'count')

# Optional: Order the queryset by the count field in descending order
queryset = queryset.order_by('-count')