Skip to content

Latest commit

 

History

History
47 lines (27 loc) · 2.3 KB

MongoAggregation.md

File metadata and controls

47 lines (27 loc) · 2.3 KB
Raw

Solve using your mongodb-compass aggregation tool

Requirements:

  • Import the restaurant.json file as a new collection

Exercise:

  1. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those restaurants which contain 'Reg' as three letters somewhere in its name.

    [{$project: { restaurant_id: 1, name: 1, borough: 1, cuisine: 1 }}, {$match: { name: { $regex: '.Reg.' } }}]

  2. Write a MongoDB query to find the restaurants which belong to the borough Bronx and prepared either American or Chinese dish.

  3. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those restaurants which belong to the borough Staten Island or Queens or Bronx or Brooklyn.

  4. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those restaurants which are not belonging to the borough Staten Island or Queens or Bronx or Brooklyn.

  5. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those restaurants which achieved a score which is not more than 10.

  6. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those restaurants which prepared dish except 'American' and 'Chinees' or restaurant's name begins with letter 'Wil'.

  7. Write a MongoDB query to find the restaurant Id, name, and grades for those restaurants which achieved a grade of "A" and scored 11 on an ISODate "2014-08-11T00:00:00Z" among many of survey dates..

  8. Write a MongoDB query to find the restaurant Id, name and grades for those restaurants where the 2nd element of grades array contains a grade of "A" and score 9 on an ISODate "2014-08-11T00:00:00Z".

  9. 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..

  10. Write a MongoDB query to arrange the name of the restaurants in ascending order along with all the columns.

  11. Write a MongoDB query to arrange the name of the restaurants in descending along with all the columns.

  12. Write a MongoDB query to arranged the name of the cuisine in ascending order and for that same cuisine borough should be in descending order.

  13. Write a MongoDB query to know whether all the addresses contains the street or not.