Skip to content

Instantly share code, notes, and snippets.

@pvoznenko

pvoznenko/hw5.3.js

Created September 11, 2014 06:16
Show Gist options
  • Save pvoznenko/1d3b48ca13a1c176b42e to your computer and use it in GitHub Desktop.
Save pvoznenko/1d3b48ca13a1c176b42e to your computer and use it in GitHub Desktop.
Download ZIP
hw5.3
Raw
hw5.3.js
db.grades.aggregate([{$unwind:"$scores"}, {$match:{"scores.type":{$ne: "quiz"}}}, {$group:{"_id": {class_id: "$class_id", student_id: "$student_id"}, avg_per_student: {"$avg": "$scores.score"}}}, {$group:{"_id": "$_id.class_id",avg: {"$avg": "$avg_per_student"}}}, {$sort: {"avg": -1}}]);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment