AND OR NOT
SELECT * FROM Person WHERE gender='male' AND age > 25;
AND IN DJANGO
Person.objects.filter(gender='male', age__gt=25)
SELECT * FROM Person WHERE gender='male' OR age > 25;
OR IN DJANGO
from django.db.models import Q Person.objects.filter(Q(gender='male') | Q(age__gt=25)))
SELECT * FROM Person WHERE NOT gender='male';
NOT IN DJANGO
Person.objects.exclude(gender='male')