从多个表中获取数据的Django ORM查询

我需要从多个表中检索数据,以显示商店名称、商店位置、商店每月销售量(单位)、每月销售额和从商店接受订单的销售人员姓名。 我的示例表示例如下:

秩序

id      total_price   added_by_id(employee id)   customer_id
1       42480         2                          1
2       74920         3                          2
3       21000         3                          2
4       42480         2                          1

订单项

order_id      unit
1             1
1             2
2             2
2             2
3             2
4             5

客户

id    full_name      location  
1     Shop1          Example location1
2     Shop2          Example location2

员工

id    full_name      
1     Employee Name1          
2     Employee Name2          

结果表应该是

shop name    location     salesperson        sales volume   monthly sales
Shop1        location1    Employee Name1     8              43630
Shop2        location2    Employee Name2     6              95920

我的尝试:

Order.objects.select_related('account_customer').all()
.values('customer_id')
.annotate(total_sales=Sum('total_price'))
.filter(created_at__year=today.year, created_at__month=today.month)

它会回来的

<QuerySet [{'customer_id': 1, 'total_sales': Decimal('43630.00')}, {'customer_id': 2, 'total_sales': Decimal('95920.00')}]>

我无法检索其他必要的信息,如店铺名称、位置、销售员姓名、销售量。

相关型号:

class Order(models.Model):
    added_by = models.ForeignKey(Employee, on_delete=models.CASCADE)
    customer = models.ForeignKey(Customer, on_delete=models.CASCADE)
    total_price = models.DecimalField(max_digits=18, decimal_places=2)

class OrderItem(models.Model):
    order = models.ForeignKey(Order, on_delete=models.CASCADE)
    unit = models.FloatField()

class Customer(models.Model):
    shop_name = models.CharField(max_length=100)
    address = models.CharField(max_length=100)

class Employee(AbstractUser):
    full_name = models.CharField(max_length=100)

如何检索所有必要的信息?