async def METHOD_NAME(self):
    ret = (
        await Book.annotate(avg=Avg("rating"))
        .filter(avg__gt=3)
        .group_by("author_id")
        .values_list("author_id", "avg")
    )
    self.assertEqual(len(ret), 1)
    self.assertEqual(ret[0][1], 4.5)