如何使用Django执行SQL LEFT JOIN？

from django.db import models

class Author(models.Model):
    name = models.CharField(max_length=100)

class Book(models.Model):
    title = models.CharField(max_length=100)
    author = models.ForeignKey(Author, on_delete=models.CASCADE, related_name='books')

from django.db.models import OuterRef, Subquery

authors_with_books = Author.objects.annotate(book_count=Count('books')).order_by('-book_count')

for author in authors_with_books:
    print(f"{author.name} has {author.book_count} books.")