Aggregation
-
MongoDB
MongoDB Aggregation for SQL Developers: GROUP BY, JOIN and More
An aggregation pipeline is a list of stages that documents flow through in order. $match works like WHERE, $group like GROUP BY, a $match after $group like HAVING, $sort like ORDER BY, $project like SELECT, and $lookup like LEFT JOIN. Put $match first so MongoDB can use indexes.
