$count accumulator in MongoDB - Mini Project: Build & Apply

Counting Documents with $count Accumulator in MongoDB

📖 Scenario: You are managing a small online bookstore database. You want to find out how many books are available in your collection.

🎯 Goal: Build a MongoDB aggregation pipeline that counts the total number of books in the books collection using the $count accumulator.

📋 What You'll Learn

Create a books collection with exactly 5 book documents, each having title and author fields.

Add a variable collectionName that stores the string "books".

Write an aggregation pipeline that uses $count to count all documents in the books collection.

Assign the aggregation pipeline result to a variable called countResult.

💡 Why This Matters

🌍 Real World

Counting documents is a common task in databases to get quick summaries, like how many books, users, or orders exist.

💼 Career

Database developers and analysts often use aggregation pipelines with <code>$count</code> to generate reports and insights.

1

Create the books collection with 5 book documents

Create a variable called books that is an array containing exactly these 5 documents: { title: "The Hobbit", author: "J.R.R. Tolkien" }, { title: "1984", author: "George Orwell" }, { title: "To Kill a Mockingbird", author: "Harper Lee" }, { title: "Pride and Prejudice", author: "Jane Austen" }, and { title: "The Great Gatsby", author: "F. Scott Fitzgerald" }.

MongoDB

const books = [
  // Your code here
];

Hint

Use an array of objects with the exact titles and authors given.

2

Add a variable for the collection name

Create a variable called collectionName and set it to the string "books".

MongoDB

const books = [
  { title: "The Hobbit", author: "J.R.R. Tolkien" },
  { title: "1984", author: "George Orwell" },
  { title: "To Kill a Mockingbird", author: "Harper Lee" },
  { title: "Pride and Prejudice", author: "Jane Austen" },
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald" }
];

// Your code here

Hint

Just assign the string "books" to collectionName.

3

Write an aggregation pipeline using $count

Create a variable called pipeline that is an array containing one stage: an object with the key $count and the value "totalBooks".

MongoDB

const books = [
  { title: "The Hobbit", author: "J.R.R. Tolkien" },
  { title: "1984", author: "George Orwell" },
  { title: "To Kill a Mockingbird", author: "Harper Lee" },
  { title: "Pride and Prejudice", author: "Jane Austen" },
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald" }
];

const collectionName = "books";

// Your code here

Hint

The pipeline is an array with one object: { $count: "totalBooks" }.

4

Assign the aggregation result to countResult

Create a variable called countResult and assign it the result of calling db.collection(collectionName).aggregate(pipeline).toArray().

MongoDB

const books = [
  { title: "The Hobbit", author: "J.R.R. Tolkien" },
  { title: "1984", author: "George Orwell" },
  { title: "To Kill a Mockingbird", author: "Harper Lee" },
  { title: "Pride and Prejudice", author: "Jane Austen" },
  { title: "The Great Gatsby", author: "F. Scott Fitzgerald" }
];

const collectionName = "books";

const pipeline = [
  { $count: "totalBooks" }
];

// Your code here

Hint

Use db.collection(collectionName).aggregate(pipeline).toArray() to get the count result.

Practice

1. What does the $count accumulator do in a MongoDB aggregation pipeline?

easy

A. Counts the number of documents in each group

B. Sums the values of a field in each group

C. Finds the maximum value in each group

D. Calculates the average of a field in each group

Solution

1. Step 1: Understand the purpose of $count

   The $count accumulator is used inside the $group stage to count how many documents belong to each group.

2. Step 2: Compare with other accumulators

   Unlike $sum, $max, or $avg, $count does not operate on field values but counts documents.

3. Final Answer:

   Counts the number of documents in each group -> Option A

4. Quick Check:

   $count = document count [OK]

Hint: Remember: $count counts documents, no field needed [OK]

Common Mistakes:

• Thinking $count sums field values
• Using $count outside $group stage
• Expecting $count to take arguments

2. Which of the following is the correct syntax to count documents per category using $count in a $group stage?

easy

A. { $group: { _id: "$category", total: { $count: "$price" } } }

B. { $group: { _id: "$category", total: { $count: "$category" } } }

C. { $group: { _id: "$category", total: { $count: "" } } }

D. { $group: { _id: "$category", total: { $count: {} } } }

Solution

1. Step 1: Recall $count syntax

   The $count accumulator does not take any arguments inside its braces; it should be empty: { $count: {} }.

2. Step 2: Check each option

   Options A, B, and D incorrectly pass a field name or string to $count, which is invalid syntax.

3. Final Answer:

   { $group: { _id: "$category", total: { $count: {} } } } -> Option D

4. Quick Check:

   Empty braces for $count = correct syntax [OK]

Hint: Use empty braces {} inside $count always [OK]

Common Mistakes:

• Passing a field name inside $count
• Using empty string instead of empty braces
• Confusing $count with $sum syntax

3. Given the collection documents:

{ "category": "A" }, { "category": "B" }, { "category": "A" }

What will be the output of this aggregation?

[ { $group: { _id: "$category", count: { $count: {} } } } ]

medium

A. SyntaxError: $count requires a field name

B. [ { "_id": "A", "count": 1 }, { "_id": "B", "count": 2 } ]

C. [ { "_id": "A", "count": 3 }, { "_id": "B", "count": 3 } ]

D. [ { "_id": "A", "count": 2 }, { "_id": "B", "count": 1 } ]

Solution

1. Step 1: Understand $count usage

   The $count accumulator is not valid inside a $group stage. It is a separate pipeline stage used to count total documents, not per group.

2. Step 2: Correct way to count documents per group

   To count documents per group, use $sum: 1 inside $group, not $count.

3. Step 3: Result of using $count inside $group

   Using $count inside $group causes a syntax error.

4. Final Answer:

   SyntaxError: $count requires a field name -> Option A

5. Quick Check:

   $count is a pipeline stage, not an accumulator [OK]

Hint: Use $sum: 1 to count documents per group, not $count [OK]

Common Mistakes:

• Using $count inside $group
• Expecting $count to count per group
• Confusing $count accumulator with $count stage

4. Identify the error in this aggregation pipeline:

[ { $group: { _id: "$type", total: { $count: "$amount" } } } ]

medium

A. Missing $match stage before $group

B. Incorrect _id field name

C. Using $count with a field argument is invalid

D. Using $count outside aggregation pipeline

Solution

1. Step 1: Check $count usage

   The $count accumulator does not accept any arguments; passing "$amount" is invalid syntax.

2. Step 2: Verify other parts

   The _id field and pipeline structure are correct; no $match is required before $group, and $count is inside aggregation.

3. Final Answer:

   Using $count with a field argument is invalid -> Option C

4. Quick Check:

   $count must have empty braces {} [OK]

Hint: Never pass a field to $count, use empty braces {} [OK]

Common Mistakes:

• Passing a field name to $count
• Thinking $count needs $match before $group
• Confusing $count with $sum

5. You want to find how many orders each customer placed, but only for customers with more than 2 orders. Which aggregation pipeline correctly uses $count to achieve this?

hard

A. [ { $match: { orders: { $gt: 2 } } }, { $group: { _id: "$customer", orderCount: { $count: {} } } } ]

B. [ { $group: { _id: "$customer", orderCount: { $sum: 1 } } }, { $match: { orderCount: { $gt: 2 } } } ]

C. [ { $group: { _id: "$customer", orderCount: { $count: "$customer" } } }, { $match: { orderCount: { $gt: 2 } } } ]

D. [ { $group: { _id: "$customer", orderCount: { $count: {} } } }, { $match: { orderCount: { $gt: 2 } } } ]

Solution

1. Step 1: Count orders per customer

   Since $count is not valid inside $group, use $sum: 1 to count documents per group.

2. Step 2: Filter customers with more than 2 orders

   Use $match after grouping to filter customers with orderCount greater than 2.

3. Final Answer:

   [ { $group: { _id: "$customer", orderCount: { $sum: 1 } } }, { $match: { orderCount: { $gt: 2 } } } ] -> Option B

4. Quick Check:

   Use $sum:1 to count per group, then filter [OK]

Hint: Use $sum: 1 inside $group to count documents, then filter with $match [OK]

Common Mistakes:

• Using $count inside $group
• Passing a field to $count
• Filtering before counting