如何在Django子查询中使用范围过滤？

from django.db import models

class Book(models.Model):
    title = models.CharField(max_length=100)
    author = models.CharField(max_length=100)
    price = models.DecimalField(max_digits=5, decimal_places=2)
    published_date = models.DateField()

from django.db.models import Subquery, OuterRef

# 子查询：找到价格在20到30之间的书籍
subquery = Book.objects.filter(
    price__gte=20,
    price__lte=30
).values('title', 'author', 'price')

# 主查询：使用子查询的结果
books_in_range = Book.objects.filter(
    id__in=Subquery(subquery)
)

# 打印结果
for book in books_in_range:
    print(book.title, book.author, book.price)