Mongo basic drills

mongo-basic.drills

Find all restaurants
db.restaurants.find({});

Find the command that makes the first 10 restaurants appear when db.restaurants is alphabetically sorted by the name property.
db.restaurants.find({}).sort({name: 1}).limit(10)

Retrieve a single restaurant by _id from the restaurants collection. This means you'll first need to get the _id for one of the restaurants imported into the databa
db.restaurants.findOne({_id: db.restaurants.findOne({})._id});

Write a command that gets all restaurants from the borough of "Queens".
db.restaurants.find({borough: "Queens"})

Write a command that gives the number of documents in db.restaurants.
db.restaurants.count()

Write a command that gives the number of restaurants whose zip code value is '11206'. Note that this property is at document.address.zipcode
db.restaurants.find({"address.zipcode": '11206'}).count()

Write a command that deletes a document from db.restaurants. This means you'll first need to get the _id for one of the restaurants imported into the database.
var objectId = db.restaurants.findOne({})._id;
db.restaurants.deleteOne({_id: objectId});

Write a command that sets the name property of a document with a specific _id to 'Bizz Bar Bang'. Make sure that you're not replacing the existing document, but instead updating only the name property.
db.restaurants.updateOne({_id: objectId}, {$set:{name: 'MIKE'}});

db.restaurants.update({'address.zipcode': '10035'}, {$set: {'address.zipcode': '10036'}}, {multi: true});