Search⌘ K
AI Features

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...

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":
...