kinisoftware/gist:5282103

Created March 31, 2013 21:38

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kinisoftware/5282103.js"></script>
Save kinisoftware/5282103 to your computer and use it in GitHub Desktop.

Download ZIP

Curso MongoDB Java - 10Gen - Week5 - HW5.2

Raw

gistfile1.js

db.zips.aggregate([{$match:{$or:[{state:"CA"}, {state:"NY"}]}}, {$group:{_id:{state:"$state", city:"$city"}, total_pop:{$sum:"$pop"}}}, {$match:{total_pop:{$gt:25000}}}, {$group:{_id:null, avg_pop:{$avg:"$total_pop"}}}])

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment