Give every employee a salary raise of `5000`. Return all employees sorted by salary descending.

Problem Statement

<p>Give every employee a <code>salary</code> raise of <code>5000</code>. Return all <code>employees</code> sorted by <code>salary</code> descending.</p>

Examples

Input: employees collection: +-----+---------+--------+ | _id | name | salary | +-----+---------+--------+ | 1 | Alice | 90000 | | 2 | Bob | 60000 | | 3 | Charlie | 75000 | +-----+---------+--------+

Output: +-----+---------+--------+ | _id | name | salary | +-----+---------+--------+ | 1 | Alice | 95000 | | 3 | Charlie | 80000 | | 2 | Bob | 65000 | +-----+---------+--------+

Explanation: The target document is modified according to the update operators and the updated document is returned.

Complexity

Time Complexity: -

Space Complexity: -

Hints

💡 Hint 1: Filter documents where a field matches any value in a list using the $in or $nin operator. 💡 Hint 2: Pass the query object to db.<collection>.find({ field: { $in: [val1, val2, ...] } }). 💡 Hint 3: Call .toArray() on the returned cursor so the function returns the array of matching documents.

Editorial & Approach

Problem Overview & Intuition

To solve "Bulk Increment ($inc on Many)", we query the MongoDB document store. The goal is to give every employee a salary raise of `5000`. return all employees sorted by salary descending. Using a targeted find query, the database engine filters and structures the BSON documents efficiently.

Step-by-Step Approach

Identify Target Collection: Access the collection through the db instance.
Construct Query / Pipeline: Build the query filter with appropriate comparison operators.
Resolve Cursor: Invoke .toArray() to transform the query cursor into the required array of documents.

Optimal Implementation (MongoDB)

function solve(db) {
  db.employees.updateMany({}, { $inc: { salary: 5000 } });
  return db.employees.find({}).sort({ salary: -1 }).toArray();
}

Complexity Analysis

Time Complexity O(N) collection scan (O(log N) if index is present on filtered fields).

Space Complexity O(K) where K is the number of returned documents in memory.

Key Considerations & Edge Cases

Empty Collections: If no documents match, the query cleanly returns an empty array [].
Missing / NULL Fields: Missing fields in documents are handled safely without throwing runtime exceptions.
Type Coercion: BSON types (ObjectId, Numbers, Strings) are compared strictly according to MongoDB specifications.

Bulk Increment ($inc on Many)

Medium

Give every employee a salary raise of 5000. Return all employees sorted by salary descending.

Example Scenarios

1Example 1

Input:

employees collection

_id	name	salary
1	Alice	90000
2	Bob	60000
3	Charlie	75000

Output:

_id	name	salary
1	Alice	95000
3	Charlie	80000
2	Bob	65000

Explanation:

The target document is modified according to the update operators and the updated document is returned.

MongoDB Editor

Loading Editor...

Query Results (JSON)

Run your MongoDB code to see results here.