Question

What query would you run in MongoDB to find all homework scores greater than or equal to 65 and sort those scores from lowest to highest?

{ "_id" : { "$oid" : "50906d7fa3c412bb040eb577" }, "student_id" : 0, "type" : "exam", "score" : 54.6535436362647 }
{ "_id" : { "$oid" : "50906d7fa3c412bb040eb578" }, "student_id" : 0, "type" : "quiz", "score" : 31.95004496742112 }
{ "_id" : { "$oid" : "50906d7fa3c412bb040eb579" }, "student_id" : 0, "type" : "homework", "score" : 14.8504576811645 }
{ "_id" : { "$oid" : "50906d7fa3c412bb040eb57a" }, "student_id" : 0, "type" : "homework", "score" : 63.98402553675503 }
{ "_id" : { "$oid" : "50906d7fa3c412bb040eb57b" }, "student_id" : 1, "type" : "exam", "score" : 74.20010837299897 }

Answer 1

To find all homework scores greater than or equal to 65 and sort them from lowest to highest in MongoDB, you can use a query with the $and operator and the sort() method.

Step-by-step explanation:

To find all homework scores greater than or equal to 65 and sort them from lowest to highest in MongoDB, you can use the following query:

db.collection.find({ $and: [{ type: 'homework' }, { score: { $gte: 65 } }]}).sort({ score: 1 })

This query searches for documents where the 'type' field is 'homework' and the 'score' field is greater than or equal to 65. It then sorts the results in ascending order based on the 'score' field.