Django example of SELECT Distinct Count by values

django_select_distinct_count_anotate.py

# Model example
class Person(models.model):
    ...
    country = moldels.CharField(...)

# Select counting by values of field country
>>> Person.objects.all().values("country").annotate(total=Count("country"))
>>> [
  {
    "country": "Brasil",
    "total": 7
  },
  {
    "country": "Denmark",
    "total": 5
  },
  {
    "country": "Egypt",
    "total": 1
  },
  {
    "country": "Finland",
    "total": 1
  },
  {
    "country": "France",
    "total": 1
  },
  {
    "country": "Germany",
    "total": 1
  },
  {
    "country": "Israel",
    "total": 1
  },
  {
    "country": "United States of America",
    "total": 1
  },  
]

Thanks! It helped me a lot!