different_cases.py

has_matches = Q(num_matches__gt=0)
more_than_5_matches = Q(num_matches__gt=5)
same_zodiac_sign = Q(zodiac_sign=my_user.zodiac_sign)

has_matches_score = 5
more_than_5_matches_score = 5
same_zodiac_sign_score = 5


scored_users = User.objects.annotate(
    num_matches=(
        Count("targets__matches_1", distinct=True) + Count("targets__matches_2", distinct=True)
    ),
    score=Case(
        When(
            has_matches & more_than_5_matches & same_zodiac_sign,
            then=Value(
                has_matches_score + more_than_5_matches_score + same_zodiac_sign_score
            ),
        ),
        When(
            has_matches & more_than_5_matches,
            then=Value(has_matches_score + more_than_5_matches_score),
        ),
        When(
            has_matches & same_zodiac_sign,
            then=Value(has_matches_score + same_zodiac_sign_score),
        ),
        When(
            has_matches,
            then=Value(has_matches_score),
        ),
        When(
            same_zodiac_sign,
            then=Value(same_zodiac_sign_score),
        ),
        default=Value(0),
        output_field=models.IntegerField(),
    ),
).order_by("-score")