Есть три таблицы:
class House(Model):
name = CharField()
location = CharField()
class Meta:
datadb = db
class Contract(Model):
name = CharField()
surname = CharField()
house = ForeignKeyField(House, related_name='contracts')
class Meta:
datadb = db
class Payment(Model):
datestamp = DateField()
Value = FloatField()
contract = ForeignKeyField(Contract, related_name='payments')
class Meta:
datadb = db
Как в один запрос вывести таблицу такого содержания:
house.name, house.location, total_contracts(count), all_payments_sum