Computer scienceSoftware development foundationsSQL and databasesDBMSMongoDBOperations and operatorsOperators

Comparison operators

Finding products within stock and price range

Report a typo

In MongoDB, which queries will return all records in a products collection where stock is less than or equal to 5 and price is greater than 50?

Select one option from the list

db.products.get({stock: {$gte: 5}, price: {$gt: 50}})

db.products.find({stock: {$lt: 5}, price: {$gt: 50}})

db.products.find({stock: {$lte: 5}}).find({price: {$gt: 50}})

db.products.find({stock: {$lte: 5}, price: {$gt: 50}})

db.products.find({stock: {$lte: 5}, price: 50})

Create a free account to access the full topic