book

Mongodb Drills

1- Find the listing detail information for the Evernote app?

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?

mongodb query

""

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

mongodb query

""

(answer)

5- Find apps that are categorized in any of the following categories: Productivity, Business, or Finance?

Hint: Use the $in operator.

mongodb query

""

(answer)

6- Find apps that have been downloaded 10,000,000 or more but have star rating lower than 3 stars?

mongodb query

""

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?

mongodb query

""

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?

mongodb query

""

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?

mongodb query

""

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 "")

mongodb query

""

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?

mongodb query

""

There are apps.

12- Find apps that have been released or updated this month (September 2015)?

Hint: You can use the $regex operator

mongodb query

""

There are apps