Mongodb Drills
mongodb query
{"n":"com.evernote"}
[]
There are 0 apps.
The star rating of the first Evernote app is:
2- How many apps developed by GO Launcher EX?
mongodb query
{"crt":"GO Launcher EX"},{"n":1}
[]
There are 0 apps.
3- How many apps have been downloaded more than 10,000,000?
""
(answer)
4- How many apps have the word "share" in their description?
Hint: the desc field is indexed with a text index. Use the $text operator.
""
(answer)
5- Find apps that are categorized in any of the following categories: Productivity, Business, or Finance?
Hint: Use the $in operator.
""
(answer)
6- Find apps that have been downloaded 10,000,000 or more but have star rating lower than 3 stars?
""
There are apps.
Hint: The query matches one app in the dataset and the link to its Google Play listing page is:
https://play.google.com/store/apps/details?id= Read the reviews to find out why?
7- Find the title and creator of apps that have been rated above 4 stars by 1,000,000 or more users?
""
There are apps.
8- Find apps whose content rating is Teen but not categorized in any of the following categories: Card, Entertainment, Comics, and Puzzle?
""
There are apps.
9- Find the title, category, download count, and star rating of apps with the phrase "in-app purchase" in their description and download count greater than 10,000,000?
""
There are apps.
10- Find the title and address of the creator of apps with download count greater than 1,000,000 and star rating greater than 4.5?
Hint: ensure that the results include apps that have creator address (not equal "")
""
There are apps.
11- Find the title, category, download count, and rating of apps with download count of 1,000,000 or more but have no privacy ststements?
""
There are apps.
12- Find apps that have been released or updated this month (September 2015)?
Hint: You can use the $regex operator
""
There are apps