M101P - Homework 3.1

m101p-hw3.1.js

db.students.find()

db.students.find().forEach(function(student) {
    var lowest = -1;
    for (var i = 0; i < student.scores.length; i++) {
        if (student.scores[i].type == 'homework') {
            lowest = lowest == -1 || student.scores[i].score < student.scores[lowest].score ? i : lowest;
        }
    }
    if (lowest > -1) {
        student.scores.splice(lowest, 1);
        db.students.save(student);
    }
})

db.students.count()
db.students.find({_id : 137}).pretty()

db.students.aggregate( { '$unwind' : '$scores' } , { '$group' : { '_id' : '$_id' , 'average' : { $avg : '$scores.score' } } } , { '$sort' : { 'average' : -1 } } , { '$limit' : 1 } )