intent: How to do this GROUP BY query in Django's ORM with annotate and aggregate
rewritten_intent: Group the values from django model `Article` with group by value `pub_date` and annotate by `title`
snippet: Article.objects.values('pub_date').annotate(article_count=Count('title'))