What are the types of queries that can be performed using both AND and OR in mongodb?

edit

In MongoDB, the following types of queries can be performed using both AND and OR operators:

1. Simple queries: You can use the AND or OR operators to combine multiple conditions in a query.

Example: db.collection.find( { $or: [ { status: "A" }, { qty: { $lt: 30 } } ] } )

1. Nested queries: You can use the AND or OR operators to combine multiple conditions in a nested query.

Example: db.collection.find( { $and: [ { "author": "John Doe" }, { $or: [ { "category": "fiction" }, { "category": "non-fiction" } ] } ] } )

1. Range queries: You can use the AND or OR operators to combine multiple range conditions in a query.

Example: db.collection.find( { $and: [ { age: { $gt: 18 } }, { age: { $lt: 30 } } ] } )

1. Regular expression searches: You can use the AND or OR operators to combine regular expressions in a query.

Example: db.collection.find( { $or: [ { name: /^A/ }, { name: /e$/ } ] } )