I'm trying to limit the number of queries I perform on a page. The queryset returns the objects created within the last 24 hours. I then want to filter that queryset to count the objects based upon a field. 

Example:

```
cars = self.get_queryset()
volvos_count = cars.filter(brand="Volvo").count()
mercs_count = cars.filter(brand="Merc").count()

```

With an increasing number of brands (in this example), the number of queries grows linearly with the number of brands that must be queried. 

How can you make a single query for the cars that returns a dict of all of the unique values for brand and the number of instances within the queryset?

Result:

```
{'volvos': 4, 'mercs': 50, ...}

```

Thanks!

EDIT: 

Of the comments so far, they have been close but not quite on the mark. Using a `values_list('brand', flat=True)` will return the brands. From there you can use 

```
 from collections import Counter 

```

To return the totals. It would be great if there is a way to do this from a single query, but maybe it isn't possible.