id | title | description | category
----+-------------------------------------+----------------------+----------
1 | blog title first | description 1 | social
2 | blog title second | description 2 | social
3 | blog title third | description 3 | community
4 | blog title fourth | description 4 | community
5 | blog title fifth | description 5 | people
I want a result to be as:
<QuerySet [{'category': 'social', 'blog_count': '2'}, {'category': 'community', 'blog_count': '2'}, {'category': 'people', 'blog_count': '1'}]>