Avg, Sum in Django

We can find the average, sum of any particular column by using aggregate in django.

We have to import from django.db.models

ex: –

from django.db.models import Avg, Sum

avg_marks = TableName.objects.filter(user_id=id).aggregate(Avg(‘marks’))

total_marks = TableName.objects.filter(user_id=id).aggregate(Sum(‘marks’))