擅长:python、mysql、java
<p>我想出来了,忘了点结果</p>
<pre><code>from django.db.models.functions import ExtractWeek, ExtractYear
from django.db.models.aggregates import Count
count = myModel.objects.annotate(year=ExtractYear('created_at')) \
.annotate(week=ExtractWeek('created_at')) \
.values('year','week') \
.annotate(count=Count('id')).order_by('count')
<QuerySet [{'year': 2019, 'week': 7, 'count': 8}]>
</code></pre>