Write Query: Using Logical Operators
To assist the logistics team, a query is needed to identify up to three recent orders with a status of "Pending" or "Processing" and a total value exceeding $500. The query should return the relevant documents from the orders collection, including all default fields, ensuring that only the most pertinent orders are prioritized for shipping.
We'll cover the following...
We'll cover the following...
Question
Given the following sample documents from the orders collection:
[
{
"_id": "3a758b14e7e292cf190b1ac5",
"customerId": "ee3c04494293e51a48af88d1",
"items": [
"External Hard Drive",
"USB Hub"
],
"total": 1922,
"status": "Processing",
"orderDate": ...