Skip to content

Latest commit

 

History

History
33 lines (17 loc) · 2.15 KB

MongoAggregation.md

File metadata and controls

33 lines (17 loc) · 2.15 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.

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