What is the method to apply two aggregation operations to lookup the same model?

edit

To apply two aggregation operations to lookup the same model, we can use the chaining method in Django's ORM. We can chain two or more aggregation functions by calling the second function on the result of the first function, and so on.

For example, to get the total count of records and the sum of a numeric field (e.g. price) in a model named Employee, we can use the following code:

from django.db.models import Sum, Count
from myapp.models import Employee

result = Employee.objects.aggregate(
    count=Count('id'),
    total=Sum('price')
)

Here, we first call the Count function to get the count of Employee records and name it as 'count'. Then we call the Sum function to get the sum of the 'price' field and name it as 'total'. The result will be a dictionary with the keys 'count' and 'total' and their respective values.