MongoDB is a document-oriented NoSQL database system. A mongodb server is installed in the lab environment (localhost). The objective of this challenge is to interact with the mongodb server and answer the following:

Questions:

1. How many databases are present is mongodb cluster?
2. How many collections are present in database users?
3. What is the value of flag obtained from the mongodb cluster?
4. What is the email address of user named “Heather” from “current” user collection?
5. How many users are present in “past” collection in users database?
6. How many cities of state “Massachusetts” are present in the collection city in database city?
7. How many cities have population greater than 15000 in the collection city in database city?
8. How many cities of state “Indiana” have population  greater than 15000 in collection “city” in database “city”?
9. How many cities of have population less than 100 or belongs to state “Indiana” in collection “city” in database “city”?
10. How many Cities have their name starting with “AN” in collection “city” in database “city”?
11. What is the name of 101st city in collection “city” when sorted in ascending order according to “city” in database “city”?
12. What is the average population in collection “city” in database “city” (Upto two decimal places)?

Reference: Database used in this exercise can be found here.

The solution for this lab can be found in the following manual: https://assets.ine.com/labs/ad-manuals/walkthrough-230.pdf