MongoDB Exercise - Find the name of the restaurants in ascending order along with all the columns
Write a MongoDB query to arrange the name of the restaurants in ascending order along with all the columns.
Structure of 'restaurants' collection :
{ "address": { "building": "1007", "coord": [ -73.856077, 40.848447 ], "street": "Morris Park Ave", "zipcode": "10462" }, "borough": "Bronx", "cuisine": "Bakery", "grades": [ { "date": { "$date": 1393804800000 }, "grade": "A", "score": 2 }, { "date": { "$date": 1378857600000 }, "grade": "A", "score": 6 }, { "date": { "$date": 1358985600000 }, "grade": "A", "score": 10 }, { "date": { "$date": 1322006400000 }, "grade": "A", "score": 9 }, { "date": { "$date": 1299715200000 }, "grade": "B", "score": 14 } ], "name": "Morris Park Bake Shop", "restaurant_id": "30075445" }
Query:
db.restaurants.find().sort({"name":1});
Output:
{ "_id" : ObjectId("564c2d949eb21ad392f1d6de"), "address" : { "building" : "154", "coord" : [ -73.9189064, 40.8654529 ], "street" : "Post Ave", "zipcode" : "10034" }, "borough" : "Manhattan", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50017887" } { "_id" : ObjectId("564c2d949eb21ad392f1d6ec"), "address" : { "building" : "508", "coord" : [ -73.999813, 40.683876 ], "street" : "Henry St", "zipcode" : "11231" }, "borough" : "Brooklyn", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50017910" } { "_id" : ObjectId("564c2d949eb21ad392f1d6ed"), "address" : { "building" : "15", "coord" : [ -73.9966882, 40.7139264 ], "street" : "Division St", "zipcode" : "10002" }, "borough" : "Manhattan", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50017912" } { "_id" : ObjectId("564c2d949eb21ad392f1d6f5"), "address" : { "building" : "4704", "coord" : [ -74.013391, 40.64943 ], "street" : "3Rd Ave", "zipcode" : "11220" }, "borough" : "Brooklyn", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50017925" } { "_id" : ObjectId("564c2d949eb21ad392f1d6f8"), "address" : { "building" : "2145", "coord" : [ -73.8668062, 40.8547454 ], "street" : "Cruger Ave", "zipcode" : "10462" }, "borough" : "Bronx", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50017935" } { "_id" : ObjectId("564c2d949eb21ad392f1d6f9"), "address" : { "building" : "567", "coord" : [ -73.9521663, 40.7172388 ], "street" : "Union Ave", "zipcode" : "11211" }, "borough" : "Brooklyn", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50017938" } { "_id" : ObjectId("564c2d949eb21ad392f1d702"), "address" : { "building" : "947", "coord" : [ -74.00435499999999, 40.653897 ], "street" : "4Th Ave", "zipcode" : "11232" }, "borough" : "Brooklyn", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50017967" } { "_id" : ObjectId("564c2d949eb21ad392f1d703"), "address" : { "building" : "1501", "coord" : [ -73.815882, 40.787061 ], "street" : "149Th St", "zipcode" : "11357" }, "borough" : "Queens", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50017969" } { "_id" : ObjectId("564c2d949eb21ad392f1d709"), "address" : { "building" : "208", "coord" : [ -73.9187426, 40.8299958 ], "street" : "E 165Th St", "zipcode" : "10456" }, "borough" : "Bronx", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50017982" } { "_id" : ObjectId("564c2d949eb21ad392f1d711"), "address" : { "building" : "2478", "coord" : [ -73.98764190000001, 40.597901 ], "street" : "86Th St", "zipcode" : "11214" }, "borough" : "Brooklyn", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018007" } { "_id" : ObjectId("564c2d949eb21ad392f1d713"), "address" : { "building" : "61", "coord" : [ -73.9835112, 40.7408627 ], "street" : "Lexington Ave", "zipcode" : "10010" }, "borough" : "Manhattan", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018012" } { "_id" : ObjectId("564c2d949eb21ad392f1d725"), "address" : { "building" : "98A", "coord" : [ -73.96413, 40.7120375 ], "street" : "S 4Th St", "zipcode" : "11249" }, "borough" : "Brooklyn", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018042" } { "_id" : ObjectId("564c2d949eb21ad392f1d729"), "address" : { "building" : "2574", "coord" : [ -73.961125, 40.594069 ], "street" : "Coney Island Ave", "zipcode" : "11223" }, "borough" : "Brooklyn", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018050" } { "_id" : ObjectId("564c2d949eb21ad392f1d72f"), "address" : { "building" : "1250", "coord" : [ -73.92937599999999, 40.6421007 ], "street" : "Utica Ave", "zipcode" : "11203" }, "borough" : "Brooklyn", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018061" } { "_id" : ObjectId("564c2d949eb21ad392f1d730"), "address" : { "building" : "76", "coord" : [ -73.9964401, 40.6951679 ], "street" : "Montague St", "zipcode" : "11201" }, "borough" : "Brooklyn", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018062" } { "_id" : ObjectId("564c2d949eb21ad392f1d738"), "address" : { "building" : "420", "coord" : [ -73.94310449999999, 40.8108763 ], "street" : "Lenox Ave", "zipcode" : "10037" }, "borough" : "Manhattan", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018083" } { "_id" : ObjectId("564c2d949eb21ad392f1d739"), "address" : { "building" : "2580", "coord" : [ -73.970705, 40.7953768 ], "street" : "Broadway", "zipcode" : "10025" }, "borough" : "Manhattan", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018085" } { "_id" : ObjectId("564c2d949eb21ad392f1d73c"), "address" : { "building" : "308", "coord" : [ -73.9372612, 40.7966002 ], "street" : "E 116Th St", "zipcode" : "10029" }, "borough" : "Manhattan", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018088" } { "_id" : ObjectId("564c2d949eb21ad392f1d73f"), "address" : { "building" : "3712", "coord" : [ -73.870897, 40.751033 ], "street" : "Junction Blvd", "zipcode" : "11368" }, "borough" : "Queens", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018095" } { "_id" : ObjectId("564c2d949eb21ad392f1d740"), "address" : { "building" : "889", "coord" : [ -73.9857624, 40.7684922 ], "street" : "9Th Ave", "zipcode" : "10019" }, "borough" : "Manhattan", "cuisine" : "Other", "grades" : [ ], "name" : "", "restaurant_id" : "50018100" } Type "it" for more
Note: This output is generated using MongoDB server version 3.6
Improve this sample solution and post your code through Disqus.
Previous: Write a MongoDB query to find the restaurant Id, name, address and geographical location for those restaurants where 2nd element of coord array contains a value which is more than 42 and upto 52.
Next: Write a MongoDB query to arrange the name of the restaurants in descending along with all the columns.
What is the difficulty level of this exercise?
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework