119👍
✅
from django.db.models import Count
top_users = User.objects.filter(problem_user=False) \
.annotate(num_submissions=Count('submission')) \
.order_by('-num_submissions')[:3]
You didn’t mention problem_user
in your example model code, but I’ve left it in assuming that it is a BooleanField
on User
.
Source:stackexchange.com