kinisoftware/gist:5282277

Created March 31, 2013 22:34

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/5282277.js"></script>
Save kinisoftware/5282277 to your computer and use it in GitHub Desktop.

Download ZIP

Course MongoDB Java - Week5 - HW5-4

Raw

gistfile1.js

db.zips.aggregate([{$project:{first_char: {$substr: ["$city", 0, 1]}, pop:1, _id:0}}, {$match:{first_char:{$lte:'9'}}}, {$group:{_id:null, total:{$sum:"$pop"}}}])

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