is it possible to aggregate sum by relation in Prisma?
so i have types [Order; Vendor]
Relation is many Order per Vendor so Order has the ID of Vendor
I want to make a query to sum the price of all orders of each vendor, so i get a number for each vendor that is the total price of their orders
Is that possible without looping over vendors?