Write a Query to find the first 2 restaurants which are in the borough Bronx.
Sample Document:
{"_id" : ObjectId("6029b6e30157be18e7ee4016"),"address" : {"building" : "1007","coord" : [-73.856077,40.848447],"street" : "Morris Park Ave","zipcode" : "10462"},"borough" : "Bronx","cuisine" : "Bakery","grades" : [{"date" : ISODate("2014-03-03T00:00:00.000+0000"),"grade" : "A","score" : 2.0},{"date" : ISODate("2013-09-11T00:00:00.000+0000"),"grade" : "A","score" : 6.0},{"date" : ISODate("2013-01-24T00:00:00.000+0000"),"grade" : "A","score" : 10.0},{"date" : ISODate("2011-11-23T00:00:00.000+0000"),"grade" : "A","score" : 9.0},{"date" : ISODate("2011-03-10T00:00:00.000+0000"),"grade" : "B","score" : 14.0}],"name" : "Morris Park Bake Shop","restaurant_id" : "30075445"}
Approach
Query: Query to find the restaurant borough=Bronx.
db.getCollection("Restaurants").find({ "borough" : "Bronx"}).limit(2);
Output:
{"_id" : ObjectId("6029b6e30157be18e7ee4016"),"address" : {"building" : "1007","coord" : [-73.856077,40.848447],"street" : "Morris Park Ave","zipcode" : "10462"},"borough" : "Bronx","cuisine" : "Bakery","grades" : [{"date" : ISODate("2014-03-03T00:00:00.000+0000"),"grade" : "A","score" : 2.0},{"date" : ISODate("2013-09-11T00:00:00.000+0000"),"grade" : "A","score" : 6.0},{"date" : ISODate("2013-01-24T00:00:00.000+0000"),"grade" : "A","score" : 10.0},{"date" : ISODate("2011-11-23T00:00:00.000+0000"),"grade" : "A","score" : 9.0},{"date" : ISODate("2011-03-10T00:00:00.000+0000"),"grade" : "B","score" : 14.0}],"name" : "Morris Park Bake Shop","restaurant_id" : "30075445"}{"_id" : ObjectId("6029bb900157be18e7ee401b"),"address" : {"building" : "351","coord" : [-73.98513559999999,40.7676919],"street" : "West 57 Street","zipcode" : "10019"},"borough" : "Bronx","cuisine" : "Irish","grades" : [{"date" : ISODate("2014-09-06T00:00:00.000+0000"),"grade" : "A","score" : 2.0},{"date" : ISODate("2013-07-22T00:00:00.000+0000"),"grade" : "A","score" : 11.0},{"date" : ISODate("2012-07-31T00:00:00.000+0000"),"grade" : "A","score" : 12.0},{"date" : ISODate("2011-12-29T00:00:00.000+0000"),"grade" : "A","score" : 12.0}],"name" : "Dj Reynolds Pub And Restaurant","restaurant_id" : "30191841"}
No comments:
Post a Comment