Help with grouping and summing query in MongoDB?

Question

NoSQL

There is a database structure of this type (statistics of sent and received e-mails):
{ from: "[email protected]", to: "[email protected]", date: new Date() }
{ from: "test @test.com", to: "[email protected]", date: new Date() }
{ from: "[email protected]", to: "[email protected]", date: new Date() }
how to make a request so that the output is in the form:
<e-mail> - <how much sent> - <how much received>

Answer 1

Have you already looked here?
docs.mongodb.org/manual/core/aggregation-introduction

Answer 2

You can make 2 simple requests: find({ from:"email" }).count() and find({ to:"email" }).count()
Better yet, store the incoming/outgoing counter in the "email/user profile" .