Skip to content

Instantly share code, notes, and snippets.

@AsifITk
Created September 9, 2022 04:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save AsifITk/ff4b4c5917050e980d1a57d0649f3e4c to your computer and use it in GitHub Desktop.
Save AsifITk/ff4b4c5917050e980d1a57d0649f3e4c to your computer and use it in GitHub Desktop.
1.db.restaurants.find();
2.db.restaurants.find({},{"restaurant_id" : 1,"name":1,"borough":1,"cuisine" :1});
3.db.restaurants.find({},{"restaurant_id" : 1,"name":1,"borough":1,"cuisine" :1,"_id":0});
4. db.restaurants.find({},{address:{zipcode:1},_id:0})
5.db.restaurants.find({},{borough:'Brooklyn',name:1}).skip(5).limit(5-10)
8. db.restaurants.find({'grades.score':{$gt: 70}}).count()
9.db.restaurants.find({grades:{$elemMatch:{score:{$lt:100,$gt:70}}}}).count()
10. {cuisine:{$ne:"American "},"grades.grade":"A",borough:{$ne:"Brooklyn"}}
11. {$and:[{cuisine:{$ne:"American "}},{cuisine:{$ne:"Chinese"}},{name:/^[^Sea]/}]}
12.sort({"cuisine":1,"borough" : -1,});
13. sort({name:1})
14. db.restaurants.find({'grades.grade':"A",'grades.score':11,'grades.date':ISODate('2013–09–11T00:00:00Z') }).count()
15. db.restaurants.find().sort({},{'name':1})
16. db.restaurants.aggregate([
{
'$match': {
'borough': 'Bronx',
'cuisine': 'Caribbean'
}
}, {
'$group': {
'_id': 0,
'count': {
'$sum': 1
}
}
}
])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment