Aggregation Pipeline

Give a real production-style example of using Aggregation Pipeline. Walk through the scenario end-to-end.

Answers use simple, clear English.