How can I use aggregate functions in Django querysets?

How can I use aggregate functions in Django querysets?

You can use the aggregate() method in Django to perform calculations on your querysets. For example, you can calculate the average, sum, or count of a field.

Can you show me an example of using aggregate()?

Sure! If you have a model called Book with a field price, you can do something like this: Book.objects.aggregate(Avg('price')) to get the average price.

What if I want to group the results by another field?

You can use annotate() in combination with aggregate(). For example, Book.objects.values('author').annotate(total_price=Sum('price')) will give you the total price of books grouped by author.

Are there any other aggregate functions I can use?

Yes, Django supports several aggregate functions like Count, Max, Min, and Sum. You can use them as needed in your queries.