TIL | Django | Django ORM과 SQL 관계 : Aggregation

Aggregation

MIN

# SQL
SELECT MIN(age) FROM Person;

# Django ORM
from django.db.models import Min
Person.object.all().aggregate(Min('age'))

MAX

# SQL
SELECT MAX(age) FROM Person;

# Django ORM
from django.db.models import Max
Person.objects.all().aggregate(Max('age'))

AVG

# SQL
SELECT AVG(age) FROM Person;

# Django ORM
from django.db.models import Avg
Person.objects.all().aggregate(Avg('age'))

SUM

# SQL
SELECT COUNT(*) FROM Person

# Django ORM
from django.db.models import Sum
Person.objects.all().aggregate(Sum('age'))

COUNT

# SQL
SELECT COUNT(*) FROM Person

# Django ORM
Person.objects.count()