How to write raw SQL or ORM for Count

[xiaopeng luo]

I am new to django ORM, I want query something like this:

input:

AAA    female    1

AAA    female    2

BBB    male       1

BBB    male       3

AAA    male       2

output

AAA    female    3

AAA    male       2

BBB    male       4

Sorry, my english is not good. Thanks for everyone help me.

[RONAK JAIN]

What you want to hear please cear that one..

Thanks 

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a297dc1f-6821-4bba-b04c-e8ce271b5a8d%40googlegroups.com.

[Luqman Shofuleji]

You need to do some little reading about Django aggregation

https://docs.djangoproject.com/en/2.2/topics/db/aggregation/#topics-db-aggregation  

Example

from django.db.models import Max, Count, Sum

Publisher.objects.values('name').annotate(dcount=Count('name'))

As seen above you can apply similar method to get Max, Sum and others

[Dvs Khamele]

Hi We are worlds first affordable Python, Django Based Web Developement Startup.
And can help you in this and related tasks / projects immidiately mere at $7 per hour.