ret=Emp.objects.values('dep').annotate(avg_salary=Avg('salary'))
print(ret)
# ---*******单表分组查询ORM总结：表名.objects.values('group by 的字段').annotate(聚合函数（'统计的字段'）
from django.db.models import Avg,Count,Min,Max
ret = models.Publish.objects.values('nid').annocate(c=Count('book__name'))
print(ret) # <querySet[{'nid':'ccc','c':'xxx'}]>
ret = models.Publish.objects.values('nid').annocate(c=Count('book__name')).values('name','c')
print(ret) # <querySet[{'name':'ccc','c':'xxx'}]>
ret = models.Publish.objects.values('nid').annocate(c=Count('book__name')).filter(name='人民出版社').values('name','c')
print(ret) # <querySet[{'name':'ccc','c':'xxx'}]>,这里面的filter相当于having，先group_by后having
其他可以参照类似上诉格式