如何在Django中执行此查询？

from myapp.models import Book

books = Book.objects.all()

books = Book.objects.filter(publication_year__gt=2010)

books = Book.objects.order_by('-publication_year')

book = Book.objects.get(id=1)

books = Book.objects.filter(author__name__startswith='A', price__lt=100)

books = Book.objects.filter(author__name="John Doe")

from django.db.models import Avg
average_price = Book.objects.all().aggregate(Avg('price'))

from django.db import connection

def my_custom_sql_query():
    with connection.cursor() as cursor:
        cursor.execute("SELECT * FROM myapp_book WHERE publication_year > %s", [2010])
        result = cursor.fetchall()
    return result