django-orm分组聚合
1. 聚合
from django.db.models import Avg, Sum, Max, Min, Count
models.Book.objects.all().aggregate(Avg("price"))
2. 分组
book_list = models.Book.objects.all().annotate(author_num=Count("author"))
1. 聚合
from django.db.models import Avg, Sum, Max, Min, Count
models.Book.objects.all().aggregate(Avg("price"))
2. 分组
book_list = models.Book.objects.all().annotate(author_num=Count("author"))