[wvenable]

With SQL you can denormalize all that (and should) to create that snapshot. But with NoSQL you can't normalize and get back a way to quickly query the number of products sold per month over the last 5 years.

[chrisco255]

Yes, this is possible with Aggregation and MapReduce: https://docs.mongodb.com/manual/aggregation/

[wvenable]

For relative values of "quickly".