kwikl3arn - GROUP BY

- INTRO
- DJANGO MODEL DATA TYPES
- CREATE TABLE
- SELECT
- WHERE
- AND,OR,NOT
- NULL
- ORDER BY
- INSERT INTO
- UPDATE
- DELETE
- AGGREGATION
- GROUP BY
- HAVING
- JOINS
- RAW QUERY

GROUP BY IN SQL

SQL

SELECT gender, COUNT(*) as count
FROM Person
GROUP BY gender;

GROUP BY IN DJANGO

DJANGO

Person.objects.values('gender').annotate(count=Count('gender'))