MIN FUNCTION IN SQL 
SELECT MIN(age)
FROM Person;

MIN FUNCTION IN DJANGO

from django.db.models import Min
 
Person.objects.all().aggregate(Min('age'))
{'age__min': 0}
MAX FUNCTION IN SQL 
SELECT MAX(age)
FROM Person;

MAX FUNCTION IN DJANGO

from django.db.models import Max
 
Person.objects.all().aggregate(Max('age')) 
{'age__max': 100}
AVG FUNCTION IN SQL 
SELECT AVG(age)
FROM Person;

AVG FUNCTION IN DJANGO

from django.db.models import Avg
 
Person.objects.all().aggregate(Avg('age')) 
{'age__avg': 50}
SUM FUNCTION IN SQL 
SELECT SUM(age)
FROM Person;

SUM FUNCTION IN DJANGO

from django.db.models import Sum
 
Person.objects.all().aggregate(Sum('age')) 
{'age__sum': 5050}
COUNT FUNCTION IN SQL 
SELECT COUNT(*)
FROM Person;

COUNT FUNCTION IN DJANGO

Person.objects.count()
Prev next