book

Mongodb Drills

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

mongodb query

{"n":"com.evernote"}

[
 {
  "_id": "56044593703498dd2a528ce6",
  "cadd": "305 Walnut Street\nRedwood City, CA 94063",
  "cat": "Productivity",
  "crat": "Everyone",
  "crt": "Evernote Corporation",
  "curl": "/store/apps/developer?id=Evernote+Corporation",
  "dct": 100000000,
  "desc": "Evernote is the modern workspace that syncs between all of your devices. Work everywhere and stay productive: • Write notes, checklists, and research • Organize web articles, docs, and photos  • Discuss your work with others, right within the app ---  “When it comes to taking all manner of notes and getting work done, Evernote is an indispensable tool.” – PC Mag --- 100 million people use it to move projects forward: WRITE & ORGANIZE • Stay focused: write in an uncluttered workspace • Get things done: make to-do's and checklists • Attach files: keep Office docs, PDFs, and photos • Get organized: notebooks and tags keep work tidy • Find anything: searchable text in notes and photos  DISCUSS & COLLABORATE • Work chat: discuss notes without leaving the app • Work together: share notebooks for team projects • Meeting prep: create agendas and action items YOUR DIGITAL ASSISTANT • Make connections: turn biz cards into contacts  • Track expenses: organize receipts, bills & invoices • Plan travel: save research and reservations ACCOMPLISH EVEN MORE WITH EVERNOTE PREMIUM Evernote is free to download and use. Evernote Premium unlocks even more productivity: ★ Offline access - work anywhere, even without a connection ★ More space - get more done with 10 GB of new uploads each month ★ Better search - search inside Office docs and attachments ★ Greater privacy - add a passcode lock on mobile ★ PDF annotation - use shapes and comments to give visual feedback ★ Unlimited business card scans - scan biz cards, save to contacts, and connect on LinkedIn  Two subscription levels: 1) Evernote Premium 2) Evernote Plus --- \"Use Evernote as the place you put everything...don’t ask yourself which device it’s on—it’s in Evernote\" – The New York Times --- Price may vary by location. Subscriptions will be charged to your credit card through your Google Play account. Your subscription will automatically renew unless canceled at least 24 hours before the end of the current period. You will not be able to cancel the subscription once activated. Manage your subscriptions in Account Settings after purchase.",
  "dtp": "September 22, 2015",
  "dtxt": "100,000,000 - 500,000,000",
  "n": "com.evernote",
  "new": "Bug fixes and miscellaneous improvements",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://evernote.com/privacy/&sa=D&usg=AFQjCNHTyefT6GQ6A6mnOKPeqKUA_qjesg",
  "rate": 4.6,
  "rct": 1313925,
  "sz": "Varies with device",
  "t": "Evernote",
  "verc": "5432",
  "id": "com.evernote-5432"
 }
]

There are 1 apps. The star rating of the first Evernote app is: 4.6

2- How many apps developed by GO Launcher EX?

mongodb query

{"crt":"GO Launcher EX"},{"n":1}

[
 {
  "_id": "56044588703498dd2a5272f3",
  "n": "com.jb.gosms.theme.getjar.savagelagoon"
 },
 {
  "_id": "56044588703498dd2a5273cc",
  "n": "com.jiubang.goscreenlock.plugin.lockscreen"
 },
 {
  "_id": "56044588703498dd2a5273cd",
  "n": "com.jiubang.goscreenlock.plugin.side"
 },
 {
  "_id": "56044594703498dd2a5290a6",
  "n": "com.gau.go.launcherex.gowidget.gopowermaster"
 },
 {
  "_id": "56044594703498dd2a5290a7",
  "n": "com.gau.go.launcherex.gowidget.newcalendarwidget.fullscreen"
 },
 {
  "_id": "56044594703498dd2a5290ab",
  "n": "com.gau.go.launcherex.gowidget.weatherwidget"
 },
 {
  "_id": "56044594703498dd2a5290d5",
  "n": "com.gau.go.launcherex.theme.defaultthemethree"
 },
 {
  "_id": "56044594703498dd2a52911a",
  "n": "com.gau.go.weatherex.appbilling.dynamicsbg.Peanuts"
 },
 {
  "_id": "56044594703498dd2a52911b",
  "n": "com.gau.go.weatherex.appbilling.dynamicsbg.enjoylife"
 },
 {
  "_id": "56044594703498dd2a52911c",
  "n": "com.gau.go.weatherex.appbilling.dynamicsbg.nature"
 },
 {
  "_id": "56044594703498dd2a52911e",
  "n": "com.gau.go.weatherex.appbilling.systemwidgetskin.outsideskin"
 },
 {
  "_id": "56044594703498dd2a52911f",
  "n": "com.gau.go.weatherex.appbilling.systemwidgetskin.peanuts"
 },
 {
  "_id": "56044594703498dd2a529120",
  "n": "com.gau.go.weatherex.appbilling.systemwidgetskin.tasteskin"
 },
 {
  "_id": "56044594703498dd2a529121",
  "n": "com.gau.go.weatherex.appbilling.systemwidgetskin.unknowplanetskin"
 },
 {
  "_id": "56044594703498dd2a529122",
  "n": "com.gau.go.weatherex.appbilling.sw.dynamicsbg.penguin"
 },
 {
  "_id": "56044594703498dd2a529123",
  "n": "com.gau.go.weatherex.appbilling.systemwidgetskin.graceskin"
 },
 {
  "_id": "56044594703498dd2a529124",
  "n": "com.gau.go.weatherex.appbilling.systemwidgetskin.elegantskin"
 },
 {
  "_id": "56044594703498dd2a529125",
  "n": "com.gau.go.weatherex.appbilling.systemwidgetskin.venusskin"
 },
 {
  "_id": "56044594703498dd2a529126",
  "n": "com.gau.go.weatherex.dynamicsbg.defaultv1"
 },
 {
  "_id": "56044594703498dd2a529127",
  "n": "com.gau.go.weatherex.language.pt_br"
 },
 {
  "_id": "56044594703498dd2a529128",
  "n": "com.gau.go.weatherex.language.ro"
 },
 {
  "_id": "56044594703498dd2a529129",
  "n": "com.gau.go.weatherex.dynamicsbg.defaultv2"
 },
 {
  "_id": "56044594703498dd2a52912a",
  "n": "com.gau.go.weatherex.dynamicsbg.defaultv3"
 },
 {
  "_id": "56044594703498dd2a52912b",
  "n": "com.gau.go.weatherex.language.sk"
 },
 {
  "_id": "56044594703498dd2a52912c",
  "n": "com.gau.go.weatherex.language.tr"
 },
 {
  "_id": "56044594703498dd2a52912d",
  "n": "com.gau.go.weatherex.language.uk"
 },
 {
  "_id": "56044594703498dd2a52912e",
  "n": "com.gau.go.weatherex.language.vi"
 },
 {
  "_id": "56044594703498dd2a52912f",
  "n": "com.gau.go.weatherex.systemwidgetskin.blacktransparentskin"
 },
 {
  "_id": "56044594703498dd2a529130",
  "n": "com.gau.go.weatherex.systemwidgetskin.bluegearskin"
 },
 {
  "_id": "56044594703498dd2a529131",
  "n": "com.gau.go.weatherex.systemwidgetskin.bottleskin"
 },
 {
  "_id": "56044594703498dd2a529132",
  "n": "com.gau.go.weatherex.systemwidgetskin.conciseblack"
 },
 {
  "_id": "56044594703498dd2a529133",
  "n": "com.gau.go.weatherex.systemwidgetskin.concisewhite"
 },
 {
  "_id": "56044594703498dd2a529134",
  "n": "com.gau.go.weatherex.systemwidgetskin.defaultskin"
 },
 {
  "_id": "56044594703498dd2a529135",
  "n": "com.gau.go.weatherex.systemwidgetskin.miuistyleskin"
 },
 {
  "_id": "56044594703498dd2a529136",
  "n": "com.gau.go.weatherex.systemwidgetskin.moonlightskin"
 },
 {
  "_id": "56044594703498dd2a529137",
  "n": "com.gau.go.weatherex.systemwidgetskin.scenery.semele"
 },
 {
  "_id": "56044594703498dd2a529138",
  "n": "com.gau.go.weatherex.theme.gowidget.blacktransparentskin"
 },
 {
  "_id": "56044594703498dd2a529139",
  "n": "com.gau.go.weatherex.theme.gowidget.quietlyelegantskinfree"
 },
 {
  "_id": "56044594703498dd2a52913c",
  "n": "com.gau.go.weatherex.language.sr"
 },
 {
  "_id": "56044594703498dd2a52913d",
  "n": "com.gau.go.weatherex.language.id"
 }
]

There are 40 apps.

3- How many apps have been downloaded more than 10,000,000?

mongodb query

{"dct":{ "$gt":10000000}},{"n":1,"dct":1}

[
 {
  "_id": "56044571703498dd2a52533c",
  "dct": 50000000,
  "n": "com.lenovo.anyshare.gps"
 },
 {
  "_id": "56044571703498dd2a525341",
  "dct": 50000000,
  "n": "com.leo.appmaster"
 },
 {
  "_id": "56044572703498dd2a52566e",
  "dct": 50000000,
  "n": "com.loudtalks"
 },
 {
  "_id": "56044572703498dd2a525b84",
  "dct": 50000000,
  "n": "com.pixlr.express"
 },
 {
  "_id": "56044572703498dd2a525db3",
  "dct": 50000000,
  "n": "com.popularapp.periodcalendar"
 },
 {
  "_id": "56044572703498dd2a525ff0",
  "dct": 50000000,
  "n": "com.psafe.msuite"
 },
 {
  "_id": "56044588703498dd2a527e4e",
  "dct": 50000000,
  "n": "com.sirma.mobile.bible.android"
 },
 {
  "_id": "56044588703498dd2a528196",
  "dct": 50000000,
  "n": "com.socialnmobile.dictapps.notepad.color.note"
 },
 {
  "_id": "56044593703498dd2a528d7d",
  "dct": 50000000,
  "n": "com.explorationbase.ExplorationLite"
 },
 {
  "_id": "56044593703498dd2a528eb1",
  "dct": 50000000,
  "n": "com.game.BMX_Boy"
 },
 {
  "_id": "56044593703498dd2a528eb4",
  "dct": 50000000,
  "n": "com.game.JewelsStar"
 },
 {
  "_id": "56044593703498dd2a528eba",
  "dct": 50000000,
  "n": "com.game.SkaterBoy"
 },
 {
  "_id": "56044593703498dd2a528f80",
  "dct": 50000000,
  "n": "com.gameloft.android.ANMP.GloftIAHM"
 },
 {
  "_id": "56044593703498dd2a528f97",
  "dct": 50000000,
  "n": "com.gameloft.android.ANMP.GloftSIHM"
 },
 {
  "_id": "56044594703498dd2a529008",
  "dct": 50000000,
  "n": "com.gamestar.pianoperfect"
 },
 {
  "_id": "56044594703498dd2a5290ab",
  "dct": 50000000,
  "n": "com.gau.go.launcherex.gowidget.weatherwidget"
 },
 {
  "_id": "5604459c703498dd2a529a12",
  "dct": 50000000,
  "n": "com.jb.gokeyboard"
 },
 {
  "_id": "560445ab703498dd2a52a9ce",
  "dct": 50000000,
  "n": "goldenshorestechnologies.brightestflashlight.free"
 },
 {
  "_id": "56044569703498dd2a5251f6",
  "dct": 100000000,
  "n": "com.antivirus"
 },
 {
  "_id": "56044571703498dd2a52525d",
  "dct": 100000000,
  "n": "com.lazyswipe"
 },
 {
  "_id": "56044572703498dd2a52563b",
  "dct": 100000000,
  "n": "com.lookout"
 },
 {
  "_id": "56044572703498dd2a525986",
  "dct": 100000000,
  "n": "com.mxtech.videoplayer.ad"
 },
 {
  "_id": "56044572703498dd2a525d10",
  "dct": 100000000,
  "n": "com.policydm"
 },
 {
  "_id": "56044588703498dd2a527290",
  "dct": 100000000,
  "n": "com.jb.gosms"
 },
 {
  "_id": "56044588703498dd2a527918",
  "dct": 100000000,
  "n": "com.sec.app.samsungprintservice"
 },
 {
  "_id": "56044588703498dd2a527abb",
  "dct": 100000000,
  "n": "com.sgiggle.production"
 },
 {
  "_id": "56044593703498dd2a528411",
  "dct": 100000000,
  "n": "com.creativemobile.DragRacing"
 },
 {
  "_id": "56044593703498dd2a528819",
  "dct": 100000000,
  "n": "com.ebay.mobile"
 },
 {
  "_id": "56044593703498dd2a528ce6",
  "dct": 100000000,
  "n": "com.evernote"
 },
 {
  "_id": "56044593703498dd2a528f76",
  "dct": 100000000,
  "n": "com.gameloft.android.ANMP.GloftDMHM"
 },
 {
  "_id": "5604459c703498dd2a529c81",
  "dct": 100000000,
  "n": "com.sonyericsson.extras.liveware"
 },
 {
  "_id": "560445ab703498dd2a52a3a6",
  "dct": 100000000,
  "n": "com.surpax.ledflashlight.panel"
 },
 {
  "_id": "56044588703498dd2a52791b",
  "dct": 500000000,
  "n": "com.sec.spp.push"
 }
]

There are 33 apps that have been downloaded more than 10M times.

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

{ "$text": { "$search": "share" } },{"n":1}

[
 {
  "_id": "560445b0703498dd2a52b51b",
  "n": "com.app.Sonline"
 },
 {
  "_id": "5604457c703498dd2a526807",
  "n": "lex.ottawamusic.biz"
 },
 {
  "_id": "5604457c703498dd2a526804",
  "n": "lex.athensmusic.biz"
 },
 {
  "_id": "56044588703498dd2a527495",
  "n": "com.jokesinhindi.santabantajokes"
 },
 {
  "_id": "56044572703498dd2a525b3a",
  "n": "com.namazandduas"
 },
 {
  "_id": "560445ac703498dd2a52ad9d",
  "n": "ipcamsoft.com.lite"
 },
 {
  "_id": "5604457c703498dd2a526c6a",
  "n": "uk.co.omobile.trafficwalesandroid"
 },
 {
  "_id": "5604457c703498dd2a5266d7",
  "n": "jp.pioneer.avsoft.android.airjam"
 },
 {
  "_id": "56044568703498dd2a52447a",
  "n": "com.aadhk.restpos"
 },
 {
  "_id": "56044588703498dd2a527bdb",
  "n": "com.shop4posh.com"
 },
 {
  "_id": "5604457c703498dd2a52678a",
  "n": "jumi.client.camlite"
 },
 {
  "_id": "56044572703498dd2a5260dd",
  "n": "com.s700apps.othaim"
 },
 {
  "_id": "56044588703498dd2a527c60",
  "n": "com.shoppingpointers"
 },
 {
  "_id": "56044593703498dd2a5286b3",
  "n": "com.cute.Mirror.Camera.Twin.Effect"
 },
 {
  "_id": "560445b0703498dd2a52b541",
  "n": "com.app.hip_hop"
 },
 {
  "_id": "560445ab703498dd2a52ab34",
  "n": "id.co.firzil.shoop_sell_online"
 },
 {
  "_id": "56044569703498dd2a5245f3",
  "n": "com.acm_honey"
 },
 {
  "_id": "56044588703498dd2a527e80",
  "n": "com.siyami.apps.patientregister"
 },
 {
  "_id": "5604459c703498dd2a529ee0",
  "n": "com.spx.uscan"
 },
 {
  "_id": "56044593703498dd2a528753",
  "n": "com.cyou.cma.clauncher.theme.v54dce78ef8c3be536e1d6b59"
 },
 {
  "_id": "56044593703498dd2a528d16",
  "n": "com.eweapons.ultimateweaponsimulator"
 },
 {
  "_id": "560445ab703498dd2a52a8a9",
  "n": "eu.vipi.android"
 },
 {
  "_id": "56044572703498dd2a525b97",
  "n": "com.pjp.qvprep.apworldhistory.lite"
 },
 {
  "_id": "56044569703498dd2a524795",
  "n": "com.afgt.glassball"
 },
 {
  "_id": "560445ab703498dd2a52a41e",
  "n": "com.swingbyswing"
 },
 {
  "_id": "5604457c703498dd2a5270df",
  "n": "com.Fashion.Model.Dress.Up.Girl.Game"
 },
 {
  "_id": "56044569703498dd2a525048",
  "n": "com.andromo.dev354518.app332824"
 },
 {
  "_id": "56044572703498dd2a525dba",
  "n": "com.popularradiostations.freegospelmusic"
 },
 {
  "_id": "56044593703498dd2a52874c",
  "n": "com.cyou.cma.clauncher.theme.v546dd9a924ec3d855d84cbcd"
 },
 {
  "_id": "56044569703498dd2a52499c",
  "n": "com.alastairbreeze.dynamickeyboard"
 },
 {
  "_id": "56044593703498dd2a528746",
  "n": "com.cyou.cma.clauncher.theme.v546585dadf8c71944ce0ffb1"
 },
 {
  "_id": "56044569703498dd2a524a95",
  "n": "com.allproperty.android.consumer.id"
 },
 {
  "_id": "56044593703498dd2a528721",
  "n": "com.cyou.cma.clauncher.theme.v53db5e715caea78415792262"
 },
 {
  "_id": "56044588703498dd2a5275b0",
  "n": "com.justgnsoft.dendenmushicallerid.lite"
 },
 {
  "_id": "56044569703498dd2a524a94",
  "n": "com.allproperty.android.consumer.my"
 },
 {
  "_id": "56044593703498dd2a5285df",
  "n": "com.cs.zero.browser"
 },
 {
  "_id": "5604459c703498dd2a529be0",
  "n": "com.solLuna.Tarot"
 },
 {
  "_id": "56044593703498dd2a52874a",
  "n": "com.cyou.cma.clauncher.theme.v5473ffb1cf23c1b22f5d9e17"
 },
 {
  "_id": "56044569703498dd2a524a99",
  "n": "com.allproperty.android.consumer.th"
 },
 {
  "_id": "56044593703498dd2a528d15",
  "n": "com.eweapons.gunsweaponsimulator"
 },
 {
  "_id": "56044588703498dd2a5281b2",
  "n": "com.socksnsandals.lwpbeautifulitalyfree"
 },
 {
  "_id": "56044572703498dd2a52590b",
  "n": "com.musclecardigitalmagazine.mcdmissue1"
 },
 {
  "_id": "560445ab703498dd2a52a939",
  "n": "gaugler.backitude"
 },
 {
  "_id": "56044569703498dd2a524ae2",
  "n": "com.alportela.pregnancyassistant"
 },
 {
  "_id": "56044588703498dd2a527343",
  "n": "com.jellybus.fxfree"
 },
 {
  "_id": "56044588703498dd2a5281ce",
  "n": "com.socksnsandals.lwpgrandrussiafree"
 },
 {
  "_id": "56044593703498dd2a528728",
  "n": "com.cyou.cma.clauncher.theme.v53e9d8f278f9841c098ff1ad"
 },
 {
  "_id": "56044593703498dd2a528750",
  "n": "com.cyou.cma.clauncher.theme.v54a36450cada3b5877300187"
 },
 {
  "_id": "56044593703498dd2a528752",
  "n": "com.cyou.cma.clauncher.theme.v5506a47b3555182f02962564"
 },
 {
  "_id": "56044572703498dd2a525db5",
  "n": "com.popularradiostations.freecomedyradio"
 },
 {
  "_id": "5604457c703498dd2a526b56",
  "n": "udk.android.reader.interactive.license"
 },
 {
  "_id": "5604457c703498dd2a527185",
  "n": "com.Girls.Beauty.Nail.Salon.Game"
 },
 {
  "_id": "56044588703498dd2a52760d",
  "n": "com.laboratory.rush"
 },
 {
  "_id": "56044588703498dd2a5281d0",
  "n": "com.socksnsandals.lwpdinosaurshadowsfree"
 },
 {
  "_id": "56044572703498dd2a525b9d",
  "n": "com.pjp.qvprep.microbiology.lite"
 },
 {
  "_id": "560445af703498dd2a52b1c4",
  "n": "com.PerfectsunLiveWallpaperHDHQ"
 },
 {
  "_id": "56044588703498dd2a5275b1",
  "n": "com.justgnsoft.dendenmushicallerid"
 },
 {
  "_id": "56044572703498dd2a525998",
  "n": "com.my.pst.suit.lady.nature.frm.news"
 },
 {
  "_id": "560445af703498dd2a52b1f0",
  "n": "com.PlopRareDiamon

There are 4197 apps that have the word "share" in their description

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

Hint: Use the $in operator.

mongodb query

{"cat":{ "$in":["Productivity","Business","Finance"]}},{"n":1,"cat":1}

[
 {
  "_id": "56044568703498dd2a5242ba",
  "cat": "Business",
  "n": "com.WadeFx.Sesimic"
 },
 {
  "_id": "56044568703498dd2a524318",
  "cat": "Business",
  "n": "com.a1.forsliding"
 },
 {
  "_id": "56044568703498dd2a52433a",
  "cat": "Business",
  "n": "com.a1169367456511228af2d4516a.a55052279a"
 },
 {
  "_id": "56044568703498dd2a524350",
  "cat": "Business",
  "n": "com.a1279459978528597bd089410a.a38159821a"
 },
 {
  "_id": "56044568703498dd2a524353",
  "cat": "Business",
  "n": "com.a1291003520520b0284674c23a.a09569249a"
 },
 {
  "_id": "56044568703498dd2a52435a",
  "cat": "Business",
  "n": "com.a135520233353d7db3a4b0873a.a26592179a"
 },
 {
  "_id": "56044568703498dd2a524365",
  "cat": "Business",
  "n": "com.a13998564240768877249"
 },
 {
  "_id": "56044568703498dd2a52436b",
  "cat": "Business",
  "n": "com.a14156691501701414410"
 },
 {
  "_id": "56044568703498dd2a52436f",
  "cat": "Business",
  "n": "com.a14357020411267574139"
 },
 {
  "_id": "56044568703498dd2a524372",
  "cat": "Business",
  "n": "com.a1446821642516a5d23e50290a.a63051998a"
 },
 {
  "_id": "56044568703498dd2a524378",
  "cat": "Business",
  "n": "com.a13879527691442994791"
 },
 {
  "_id": "56044568703498dd2a524379",
  "cat": "Business",
  "n": "com.a142303527954f54f39c01ac0a.a98135634a"
 },
 {
  "_id": "56044568703498dd2a524384",
  "cat": "Business",
  "n": "com.a1539078411512922f661adf3a.a01741217a"
 },
 {
  "_id": "56044568703498dd2a52438e",
  "cat": "Business",
  "n": "com.a158834728750243eb69e4d25a.a72233320a"
 },
 {
  "_id": "56044568703498dd2a52438f",
  "cat": "Business",
  "n": "com.a1575132500510fdf7f6f54e1a.a14870550a"
 },
 {
  "_id": "56044568703498dd2a524393",
  "cat": "Business",
  "n": "com.a16014710515166a2cce76761a.a15916513a"
 },
 {
  "_id": "56044568703498dd2a5243a3",
  "cat": "Business",
  "n": "com.a1717801752502a9e9792ec46a.a39181966a"
 },
 {
  "_id": "56044568703498dd2a5243f8",
  "cat": "Business",
  "n": "com.a262949193547bbb3aa0a9b6a.a55002610a"
 },
 {
  "_id": "56044568703498dd2a52441b",
  "cat": "Business",
  "n": "com.a408422289528583a6dcb902a.a30198090a"
 },
 {
  "_id": "56044568703498dd2a524429",
  "cat": "Business",
  "n": "com.a555027994ffdfa74a0a798a.a91931759a"
 },
 {
  "_id": "56044568703498dd2a524430",
  "cat": "Business",
  "n": "com.a572548969528fc802382cc8a.a96958648a"
 },
 {
  "_id": "56044568703498dd2a524437",
  "cat": "Business",
  "n": "com.a590470799510fb74aa7cfb7a.a91280198a"
 },
 {
  "_id": "56044568703498dd2a52444e",
  "cat": "Business",
  "n": "com.a68005602250251ef0c2cf24a.a22739136a"
 },
 {
  "_id": "56044568703498dd2a52447a",
  "cat": "Business",
  "n": "com.aadhk.restpos"
 },
 {
  "_id": "56044568703498dd2a52447b",
  "cat": "Business",
  "n": "com.aadhk.time"
 },
 {
  "_id": "56044568703498dd2a52447d",
  "cat": "Business",
  "n": "com.aadi.shinemp"
 },
 {
  "_id": "56044568703498dd2a5244b8",
  "cat": "Business",
  "n": "com.aaron.birddog"
 },
 {
  "_id": "56044568703498dd2a5244b9",
  "cat": "Business",
  "n": "com.aaron.kwan"
 },
 {
  "_id": "56044568703498dd2a5244bc",
  "cat": "Business",
  "n": "com.aasaanjobs.employee.aasaanjobsemployee"
 },
 {
  "_id": "56044568703498dd2a5244c2",
  "cat": "Business",
  "n": "com.aastocks.hkis"
 },
 {
  "_id": "56044568703498dd2a5244c7",
  "cat": "Business",
  "n": "com.aastocks.susl"
 },
 {
  "_id": "56044568703498dd2a5244c8",
  "cat": "Business",
  "n": "com.aavid.qcchamber"
 },
 {
  "_id": "56044568703498dd2a5244d3",
  "cat": "Business",
  "n": "com.abacus.android"
 },
 {
  "_id": "56044568703498dd2a5244e4",
  "cat": "Business",
  "n": "com.abc.passportnomadinventorybyod"
 },
 {
  "_id": "56044568703498dd2a5244e6",
  "cat": "Business",
  "n": "com.abc.meeting22"
 },
 {
  "_id": "56044568703498dd2a5244e8",
  "cat": "Business",
  "n": "com.abc.passportnomadreceivingbyod"
 },
 {
  "_id": "56044568703498dd2a5244e9",
  "cat": "Business",
  "n": "com.abc.passportnomadorderingbyod"
 },
 {
  "_id": "56044568703498dd2a5244ea",
  "cat": "Business",
  "n": "com.abc.passportnomadreturnsbyod"
 },
 {
  "_id": "56044568703498dd2a52450e",
  "cat": "Business",
  "n": "com.abhi.tabswipe"
 },
 {
  "_id": "56044569703498dd2a524540",
  "cat": "Business",
  "n": "com.abrafer.srl"
 },
 {
  "_id": "56044569703498dd2a524545",
  "cat": "Business",
  "n": "com.abrc.saudamanager.activities"
 },
 {
  "_id": "56044569703498dd2a52454b",
  "cat": "Business",
  "n": "com.absmallbusinessmarketing.MyLawyer"
 },
 {
  "_id": "56044569703498dd2a52454e",
  "cat": "Business",
  "n": "com.absmallbusinessmarketing.askacriminaldefenselawyer"
 },
 {
  "_id": "56044569703498dd2a52454f",
  "cat": "Business",
  "n": "com.absmallbusinessmarketing.askalawyer"
 },
 {
  "_id": "56044569703498dd2a52455b",
  "cat": "Business",
  "n": "com.absolutetroubleshoot.airconditioning"
 },
 {
  "_id": "56044569703498dd2a52455c",
  "cat": "Business",
  "n": "com.absolutetroubleshoot.furnaces"
 },
 {
  "_id": "56044569703498dd2a52455d",
  "cat": "Business",
  "n": "com.absolutetroubleshoot.refrigerationpullman"

There are 3179 apps that are categorized in any of the following categories: Productivity, Business, or Finance

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

mongodb query

{"$and":[{"dct":{ "$gte":10000000}},{"rate":{"$lt":3}}]},{"n":1,"dct":1}

[
 {
  "_id": "5604457c703498dd2a526fda",
  "dct": 10000000,
  "n": "xrayscan.regque"
 }
]

There are 1 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=xrayscan.regque 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

{"$and":[{"rct":{ "$gte":1000000}},{"rate":{"$gte":4}}]},{"n":1,"crt":1}

[
 {
  "_id": "5604459c703498dd2a52988a",
  "crt": "Glu",
  "n": "com.glu.flcn_new"
 },
 {
  "_id": "56044593703498dd2a528f74",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftD4HM"
 },
 {
  "_id": "56044594703498dd2a5290ab",
  "crt": "GO Launcher EX",
  "n": "com.gau.go.launcherex.gowidget.weatherwidget"
 },
 {
  "_id": "56044593703498dd2a528f84",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftIVHM"
 },
 {
  "_id": "5604457c703498dd2a526687",
  "crt": "LINE Corporation",
  "n": "jp.naver.SJLGPP"
 },
 {
  "_id": "56044593703498dd2a528f83",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftINHM"
 },
 {
  "_id": "56044588703498dd2a527877",
  "crt": "SCIMOB",
  "n": "com.scimob.ninetyfour.percent"
 },
 {
  "_id": "56044572703498dd2a525b56",
  "crt": "RiliSoft",
  "n": "com.pixel.gun3d"
 },
 {
  "_id": "560445ab703498dd2a52a9ce",
  "crt": "GoldenShores Technologies, LLC",
  "n": "goldenshorestechnologies.brightestflashlight.free"
 },
 {
  "_id": "56044593703498dd2a528ce6",
  "crt": "Evernote Corporation",
  "n": "com.evernote"
 },
 {
  "_id": "56044593703498dd2a528f82",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftIMHM"
 },
 {
  "_id": "56044593703498dd2a528795",
  "crt": "ELECTRONIC ARTS",
  "n": "com.ea.game.simcitymobile_row"
 },
 {
  "_id": "56044572703498dd2a52545c",
  "crt": "LINE Corporation",
  "n": "com.linecorp.LGRGS"
 },
 {
  "_id": "56044588703498dd2a527e4e",
  "crt": "LifeChurch.tv",
  "n": "com.sirma.mobile.bible.android"
 },
 {
  "_id": "56044593703498dd2a528f92",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftRAHM"
 },
 {
  "_id": "56044588703498dd2a528196",
  "crt": "Notes",
  "n": "com.socialnmobile.dictapps.notepad.color.note"
 },
 {
  "_id": "56044593703498dd2a528f98",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftSXHM"
 },
 {
  "_id": "5604457c703498dd2a526f2a",
  "crt": "Wattpad.com",
  "n": "wp.wattpad"
 },
 {
  "_id": "56044593703498dd2a528f7c",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftGGHM"
 },
 {
  "_id": "56044593703498dd2a528819",
  "crt": "eBay Mobile",
  "n": "com.ebay.mobile"
 },
 {
  "_id": "56044593703498dd2a528f97",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftSIHM"
 },
 {
  "_id": "56044572703498dd2a525eb6",
  "crt": "Pretty Simple",
  "n": "com.prettysimple.criminalcaseandroid"
 },
 {
  "_id": "56044593703498dd2a528f80",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftIAHM"
 },
 {
  "_id": "56044572703498dd2a525ff0",
  "crt": "PSafe Tecnologia S.A.",
  "n": "com.psafe.msuite"
 },
 {
  "_id": "560445ab703498dd2a52a88c",
  "crt": "Nordeus",
  "n": "eu.nordeus.topeleven.android"
 },
 {
  "_id": "56044572703498dd2a525db3",
  "crt": "ABISHKKING",
  "n": "com.popularapp.periodcalendar"
 },
 {
  "_id": "56044593703498dd2a528411",
  "crt": "Creative Mobile",
  "n": "com.creativemobile.DragRacing"
 },
 {
  "_id": "56044588703498dd2a527290",
  "crt": "GO Dev Team",
  "n": "com.jb.gosms"
 },
 {
  "_id": "5604459c703498dd2a529a12",
  "crt": "GO Dev Team",
  "n": "com.jb.gokeyboard"
 },
 {
  "_id": "560445ab703498dd2a52a7b9",
  "crt": "socialpoint",
  "n": "es.socialpoint.DragonCity"
 },
 {
  "_id": "56044571703498dd2a52525d",
  "crt": "Holaverse Group",
  "n": "com.lazyswipe"
 },
 {
  "_id": "560445ac703498dd2a52b137",
  "crt": "Next Floor Corp.",
  "n": "com.NextFloor.DragonFlightKakao"
 },
 {
  "_id": "56044588703498dd2a527abb",
  "crt": "Tango",
  "n": "com.sgiggle.production"
 },
 {
  "_id": "56044572703498dd2a525986",
  "crt": "J2 Interactive",
  "n": "com.mxtech.videoplayer.ad"
 },
 {
  "_id": "56044569703498dd2a5251f6",
  "crt": "AVG Mobile",
  "n": "com.antivirus"
 },
 {
  "_id": "56044593703498dd2a528f6e",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftA8HM"
 },
 {
  "_id": "560445ab703498dd2a52a3a6",
  "crt": "Surpax Inc.",
  "n": "com.surpax.ledflashlight.panel"
 },
 {
  "_id": "56044593703498dd2a528f76",
  "crt": "Gameloft",
  "n": "com.gameloft.android.ANMP.GloftDMHM"
 }
]

There are 38 apps that have been rated above 4 stars by 1,000,000 or more users.

8- Find apps whose content rating is Teen but not categorized in any of the following categories: Card, Entertainment, Comics, and Puzzle?

mongodb query

{"$and":[{"crat":"Teen"}, {"cat":{"$nin":["Card", "Entertainment", "Comics", "Puzzle"]}}]},{"n":1,"cat":1}

[
 {
  "_id": "56044568703498dd2a524300",
  "cat": "Arcade",
  "n": "com.YannitellBrothers.CommieZombies"
 },
 {
  "_id": "56044568703498dd2a524373",
  "cat": "News & Magazines",
  "n": "com.a14468491355082a2c930ecb4a.a64478149a"
 },
 {
  "_id": "56044568703498dd2a524388",
  "cat": "News & Magazines",
  "n": "com.a1570349524533090925fbed9a.a58619747a"
 },
 {
  "_id": "56044568703498dd2a524395",
  "cat": "Sports",
  "n": "com.a1603181845246ddff6b4e19a.a03181954a"
 },
 {
  "_id": "56044568703498dd2a5243d2",
  "cat": "Sports",
  "n": "com.a1ec5cee3_b7e7_474c_ae87_f6706e546661"
 },
 {
  "_id": "56044568703498dd2a5243d9",
  "cat": "Social",
  "n": "com.a1wisdom.app"
 },
 {
  "_id": "56044568703498dd2a5243dd",
  "cat": "Sports",
  "n": "com.a2045759210540b0cc91a9dc6a.a00501049a"
 },
 {
  "_id": "56044568703498dd2a5243fc",
  "cat": "Sports",
  "n": "com.a248218658520d4ee04aec54a.a25507330a"
 },
 {
  "_id": "56044568703498dd2a524460",
  "cat": "Health & Fitness",
  "n": "com.a9229507145011b0801df630a.a64556768a"
 },
 {
  "_id": "56044568703498dd2a524463",
  "cat": "Sports",
  "n": "com.a941384341520d10ed5b98c1a.a83724543a"
 },
 {
  "_id": "56044568703498dd2a524471",
  "cat": "Arcade",
  "n": "com.aaappdev.Ypgshootterrorist"
 },
 {
  "_id": "56044568703498dd2a5244a1",
  "cat": "Books & Reference",
  "n": "com.aapvs.international.poems.lite"
 },
 {
  "_id": "56044568703498dd2a5244a2",
  "cat": "Books & Reference",
  "n": "com.aapvs.international.lovestories5.lite"
 },
 {
  "_id": "56044568703498dd2a5244ad",
  "cat": "Books & Reference",
  "n": "com.aarifwaghoo.tarjamaneahlesunnat.AOUYNELRJDUHIYKBW"
 },
 {
  "_id": "56044568703498dd2a5244ca",
  "cat": "Books & Reference",
  "n": "com.ab.voxclub"
 },
 {
  "_id": "56044568703498dd2a5244de",
  "cat": "Books & Reference",
  "n": "com.abbyy.mobile.lingvo.market"
 },
 {
  "_id": "56044568703498dd2a5244ec",
  "cat": "Action",
  "n": "com.abcfamily.stitchers.hackthecase"
 },
 {
  "_id": "56044569703498dd2a52454c",
  "cat": "Media & Video",
  "n": "com.absi.tfctv"
 },
 {
  "_id": "56044569703498dd2a524553",
  "cat": "Action",
  "n": "com.absologix.navy.commando.strike"
 },
 {
  "_id": "56044569703498dd2a524554",
  "cat": "Action",
  "n": "com.absologix.heli.air.attack"
 },
 {
  "_id": "56044569703498dd2a524592",
  "cat": "Adventure",
  "n": "com.accelainc.himitusna.en.droid"
 },
 {
  "_id": "56044569703498dd2a524593",
  "cat": "Simulation",
  "n": "com.accelainc.psychixx.en.droid"
 },
 {
  "_id": "56044569703498dd2a524596",
  "cat": "Casual",
  "n": "com.accelainc.himitsuna.ko.droid"
 },
 {
  "_id": "56044569703498dd2a524597",
  "cat": "Adventure",
  "n": "com.accelainc.kindan.ko.droid"
 },
 {
  "_id": "56044569703498dd2a52464b",
  "cat": "Arcade",
  "n": "com.activision.cabelas.biggamehunter"
 },
 {
  "_id": "56044569703498dd2a52464c",
  "cat": "Action",
  "n": "com.activision.callofduty.heroes"
 },
 {
  "_id": "56044569703498dd2a524654",
  "cat": "Action",
  "n": "com.actoz.gca"
 },
 {
  "_id": "56044569703498dd2a524655",
  "cat": "Action",
  "n": "com.actoz.mb"
 },
 {
  "_id": "56044569703498dd2a524656",
  "cat": "Role Playing",
  "n": "com.actoz.won"
 },
 {
  "_id": "56044569703498dd2a52466a",
  "cat": "Music & Audio",
  "n": "com.ad60.songza"
 },
 {
  "_id": "56044569703498dd2a52467d",
  "cat": "Casual",
  "n": "com.adamschmelzle.origami.tulip"
 },
 {
  "_id": "56044569703498dd2a524689",
  "cat": "News & Magazines",
  "n": "com.adbuddiz"
 },
 {
  "_id": "56044569703498dd2a52469d",
  "cat": "Weather",
  "n": "com.adcoms.Weather"
 },
 {
  "_id": "56044569703498dd2a52470e",
  "cat": "Lifestyle",
  "n": "com.adrimes"
 },
 {
  "_id": "56044569703498dd2a52475d",
  "cat": "Arcade",
  "n": "com.aemobile.games.luckyfishing"
 },
 {
  "_id": "56044569703498dd2a524769",
  "cat": "Role Playing",
  "n": "com.aeriamobile.bloodstone.android"
 },
 {
  "_id": "56044569703498dd2a52477b",
  "cat": "Tools",
  "n": "com.aexol.splitscale"
 },
 {
  "_id": "56044569703498dd2a524784",
  "cat": "Lifestyle",
  "n": "com.affine.elrufai"
 },
 {
  "_id": "56044569703498dd2a524797",
  "cat": "Action",
  "n": "com.affufstudio.battleshipcombatsimulator"
 },
 {
  "_id": "56044569703498dd2a524799",
  "cat": "Sports",
  "n": "com.afjcjsbx.pronosticionline1x2"
 },
 {
  "_id": "56044569703498dd2a5247af",
  "cat": "News & Magazines",
  "n": "com.africandiscuss"
 },
 {
  "_id": "56044569703498dd2a5247b4",
  "cat": "Social",
  "n": "com.african.proverbs"
 },
 {
  "_id": "56044569703498dd2a5247bf",
  "cat": "Social",
  "n": "com.afty.geekchat"
 },
 {
  "_id": "56044569703498dd2a5247c8",
  "cat": "Arcade",
  "n": "com.afuffstudio.zombiebugsmasher"
 },
 {
  "_id": "56044569703498dd2a5247cd",
  "cat": "Action",
  "n": "com.agaming.mentalhospitaliiilite"
 },
 {
  "_id": "56044569703498dd2a5247ce",
  "cat": "Role Playing",
  "n": "com.agaming.mentalhospitallite"
 },
 {
  "_id": "56044569703498dd2a5247de",
  "cat": "Action",
  "n": "com.aged.PunchBear"
 },
 {
  "_id": "56044569703498dd2a524812",
  "cat": "Action",
  "n"

There are 1520 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

{ "$and":[{"$text": { "$search": "in-app purchase" }},{"dct":{ "$gt":10000000}}] },{"n":1,"cat":1,"rate":1,"dct":1}

[
 {
  "_id": "56044593703498dd2a528819",
  "cat": "Shopping",
  "dct": 100000000,
  "n": "com.ebay.mobile",
  "rate": 4.2
 },
 {
  "_id": "56044571703498dd2a52533c",
  "cat": "Tools",
  "dct": 50000000,
  "n": "com.lenovo.anyshare.gps",
  "rate": 4.4
 },
 {
  "_id": "56044588703498dd2a527290",
  "cat": "Communication",
  "dct": 100000000,
  "n": "com.jb.gosms",
  "rate": 4.4
 },
 {
  "_id": "56044572703498dd2a52563b",
  "cat": "Tools",
  "dct": 100000000,
  "n": "com.lookout",
  "rate": 4.4
 },
 {
  "_id": "56044594703498dd2a529008",
  "cat": "Music & Audio",
  "dct": 50000000,
  "n": "com.gamestar.pianoperfect",
  "rate": 4.3
 },
 {
  "_id": "56044593703498dd2a528f97",
  "cat": "Action",
  "dct": 50000000,
  "n": "com.gameloft.android.ANMP.GloftSIHM",
  "rate": 4.2
 },
 {
  "_id": "56044593703498dd2a528f76",
  "cat": "Casual Action & Adventure",
  "dct": 100000000,
  "n": "com.gameloft.android.ANMP.GloftDMHM",
  "rate": 4.4
 },
 {
  "_id": "56044588703498dd2a528196",
  "cat": "Productivity",
  "dct": 50000000,
  "n": "com.socialnmobile.dictapps.notepad.color.note",
  "rate": 4.5
 },
 {
  "_id": "56044588703498dd2a527e4e",
  "cat": "Books & Reference",
  "dct": 50000000,
  "n": "com.sirma.mobile.bible.android",
  "rate": 4.6
 },
 {
  "_id": "56044569703498dd2a5251f6",
  "cat": "Communication",
  "dct": 100000000,
  "n": "com.antivirus",
  "rate": 4.4
 },
 {
  "_id": "56044572703498dd2a525986",
  "cat": "Media & Video",
  "dct": 100000000,
  "n": "com.mxtech.videoplayer.ad",
  "rate": 4.4
 },
 {
  "_id": "56044572703498dd2a525db3",
  "cat": "Health & Fitness",
  "dct": 50000000,
  "n": "com.popularapp.periodcalendar",
  "rate": 4.7
 },
 {
  "_id": "56044593703498dd2a528ce6",
  "cat": "Productivity",
  "dct": 100000000,
  "n": "com.evernote",
  "rate": 4.6
 },
 {
  "_id": "56044572703498dd2a52566e",
  "cat": "Social",
  "dct": 50000000,
  "n": "com.loudtalks",
  "rate": 4.4
 },
 {
  "_id": "56044588703498dd2a52791b",
  "cat": "Communication",
  "dct": 500000000,
  "n": "com.sec.spp.push",
  "rate": 4
 },
 {
  "_id": "56044594703498dd2a5290ab",
  "cat": "Weather",
  "dct": 50000000,
  "n": "com.gau.go.launcherex.gowidget.weatherwidget",
  "rate": 4.5
 },
 {
  "_id": "5604459c703498dd2a529a12",
  "cat": "Productivity",
  "dct": 50000000,
  "n": "com.jb.gokeyboard",
  "rate": 4.4
 },
 {
  "_id": "5604459c703498dd2a529c81",
  "cat": "Tools",
  "dct": 100000000,
  "n": "com.sonyericsson.extras.liveware",
  "rate": 4.2
 },
 {
  "_id": "56044593703498dd2a528f80",
  "cat": "Casual",
  "dct": 50000000,
  "n": "com.gameloft.android.ANMP.GloftIAHM",
  "rate": 4.4
 },
 {
  "_id": "56044571703498dd2a52525d",
  "cat": "Productivity",
  "dct": 100000000,
  "n": "com.lazyswipe",
  "rate": 4.5
 },
 {
  "_id": "56044572703498dd2a525ff0",
  "cat": "Tools",
  "dct": 50000000,
  "n": "com.psafe.msuite",
  "rate": 4.5
 },
 {
  "_id": "56044571703498dd2a525341",
  "cat": "Tools",
  "dct": 50000000,
  "n": "com.leo.appmaster",
  "rate": 4.3
 },
 {
  "_id": "56044588703498dd2a527918",
  "cat": "Productivity",
  "dct": 100000000,
  "n": "com.sec.app.samsungprintservice",
  "rate": 4.1
 },
 {
  "_id": "560445ab703498dd2a52a9ce",
  "cat": "Tools",
  "dct": 50000000,
  "n": "goldenshorestechnologies.brightestflashlight.free",
  "rate": 4.7
 }
]

There are 24 apps with the phrase "in-app purchase" in their description and download count greater than 10,000,000

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

{ "$and":[{ "cadd": {"$ne":"" }},{"dct":{ "$gt":1000000}},{"rate":{"$gt":4.5}}] },{"n":1,"cadd":1}

[
 {
  "_id": "5604457c703498dd2a526263",
  "cadd": "4880 Santa Rosa Rd\nCamarillo, CA 93012",
  "n": "joansoft.dailybible"
 },
 {
  "_id": "56044593703498dd2a528dfc",
  "cadd": "Perth, Western Australia",
  "n": "com.ezone.Diversion"
 },
 {
  "_id": "56044594703498dd2a52901a",
  "cadd": "999 N Sepulveda Blvd, Ste 150, El Segundo, CA, United States",
  "n": "com.gamevil.cartoonwars.gunner.global"
 },
 {
  "_id": "5604459c703498dd2a52988c",
  "cadd": "500 Howard St. Suite 300\nSan Francisco CA 94105",
  "n": "com.glu.gladiator2"
 },
 {
  "_id": "5604459c703498dd2a529890",
  "cadd": "500 Howard St. Suite 300\nSan Francisco CA 94105",
  "n": "com.glu.ewarriors2"
 },
 {
  "_id": "5604459c703498dd2a529893",
  "cadd": "500 Howard St. Suite 300\nSan Francisco CA 94105",
  "n": "com.glu.samuzombie"
 },
 {
  "_id": "5604459c703498dd2a529dda",
  "cadd": "Mussenstraat 15\n1223 RB Hilversum",
  "n": "com.spilgames.mydolphinshow"
 },
 {
  "_id": "5604459c703498dd2a52a07b",
  "cadd": "Strava, Inc\n500 Third Street, Suite 110\nSan Francisco, CA 94107",
  "n": "com.strava"
 },
 {
  "_id": "560445ac703498dd2a52ade5",
  "cadd": "Reggio Calabria, Italy",
  "n": "it.android.demi.elettronica"
 },
 {
  "_id": "5604457c703498dd2a526a46",
  "cadd": "SOLEC 81B LOK A-51, Warsaw, Poland.",
  "n": "net.audiko2"
 },
 {
  "_id": "56044588703498dd2a527892",
  "cadd": "Zippora street, Dekk House\nProvidence industrial estate\nMahe\nSeychelles",
  "n": "com.scores365"
 },
 {
  "_id": "56044588703498dd2a527a5c",
  "cadd": "Suite 05, 20th Floor, Tower One, Lippo Centre, 89 Queensway\nHong Kong",
  "n": "com.seventeenbullets.android.island"
 },
 {
  "_id": "5604459c703498dd2a52988b",
  "cadd": "500 Howard St. Suite 300\nSan Francisco CA 94105",
  "n": "com.glu.gladiator"
 },
 {
  "_id": "560445ab703498dd2a52a935",
  "cadd": "9737 Washingtonian Blvd, Suite 200\nGaithersburg, MD 20878",
  "n": "gbis.gbandroid"
 },
 {
  "_id": "560445ac703498dd2a52b137",
  "cadd": "8F, 479, Gangnam-daero, Seocho-gu, Seoul\n06541",
  "n": "com.NextFloor.DragonFlightKakao"
 },
 {
  "_id": "56044572703498dd2a525db3",
  "cadd": "UNIT04， 7/F, BRIGHT WAY TOWER, NO.33 MONG KOK ROAD , KOWLOON , HK",
  "n": "com.popularapp.periodcalendar"
 },
 {
  "_id": "56044593703498dd2a528ce6",
  "cadd": "305 Walnut Street\nRedwood City, CA 94063",
  "n": "com.evernote"
 }
]

There are 17 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

{ "$and":[{ "purl": {"$eq":"" }},{"dct":{ "$gte":1000000}}] },{"n":1,"cat":1,"dct":1,"rate":1}

[
 {
  "_id": "56044568703498dd2a524297",
  "cat": "Tools",
  "dct": 1000000,
  "n": "com.ViQ.Productivity.MobileNumberTracker",
  "rate": 3.9
 },
 {
  "_id": "56044568703498dd2a5242e6",
  "cat": "Entertainment",
  "dct": 1000000,
  "n": "com.WiredDFW.DIRECTV.unWiredRemoteLite",
  "rate": 4.4
 },
 {
  "_id": "56044568703498dd2a5243a8",
  "cat": "Entertainment",
  "dct": 1000000,
  "n": "com.a17350648352d48db91a4413a.a89436633a",
  "rate": 3.7
 },
 {
  "_id": "56044568703498dd2a5244c0",
  "cat": "Finance",
  "dct": 1000000,
  "n": "com.aastocks.dzh",
  "rate": 3.9
 },
 {
  "_id": "56044568703498dd2a5244e7",
  "cat": "Action",
  "dct": 1000000,
  "n": "com.abc.overcraft",
  "rate": 3.3
 },
 {
  "_id": "56044569703498dd2a524547",
  "cat": "Finance",
  "dct": 1000000,
  "n": "com.abnamro.nl.mobile.payments",
  "rate": 4.3
 },
 {
  "_id": "56044569703498dd2a524553",
  "cat": "Action",
  "dct": 1000000,
  "n": "com.absologix.navy.commando.strike",
  "rate": 3.7
 },
 {
  "_id": "56044569703498dd2a524554",
  "cat": "Action",
  "dct": 1000000,
  "n": "com.absologix.heli.air.attack",
  "rate": 3.7
 },
 {
  "_id": "56044569703498dd2a52456c",
  "cat": "Entertainment",
  "dct": 1000000,
  "n": "com.abto.gnhm",
  "rate": 3.9
 },
 {
  "_id": "56044569703498dd2a52456e",
  "cat": "Casual",
  "dct": 1000000,
  "n": "com.abto.morenails",
  "rate": 3.8
 },
 {
  "_id": "56044569703498dd2a52458f",
  "cat": "Tools",
  "dct": 1000000,
  "n": "com.accaci",
  "rate": 4.2
 },
 {
  "_id": "56044569703498dd2a5245d0",
  "cat": "Puzzle",
  "dct": 1000000,
  "n": "com.aceviral.clowningaroundfree",
  "rate": 4.3
 },
 {
  "_id": "56044569703498dd2a5245d2",
  "cat": "Racing",
  "dct": 1000000,
  "n": "com.aceviral.rage",
  "rate": 4.1
 },
 {
  "_id": "56044569703498dd2a5245db",
  "cat": "Personalization",
  "dct": 1000000,
  "n": "com.achep.acdisplay",
  "rate": 4.2
 },
 {
  "_id": "56044569703498dd2a524623",
  "cat": "Lifestyle",
  "dct": 1000000,
  "n": "com.acotel.astri",
  "rate": 4.2
 },
 {
  "_id": "56044569703498dd2a524654",
  "cat": "Action",
  "dct": 1000000,
  "n": "com.actoz.gca",
  "rate": 4
 },
 {
  "_id": "56044569703498dd2a524656",
  "cat": "Role Playing",
  "dct": 1000000,
  "n": "com.actoz.won",
  "rate": 4.1
 },
 {
  "_id": "56044569703498dd2a524732",
  "cat": "Racing",
  "dct": 1000000,
  "n": "com.advancedtinylab.thunderracing",
  "rate": 3.7
 },
 {
  "_id": "56044569703498dd2a524733",
  "cat": "Racing",
  "dct": 1000000,
  "n": "com.advancedtinylab.streetdriving",
  "rate": 3.6
 },
 {
  "_id": "56044569703498dd2a52473d",
  "cat": "Finance",
  "dct": 1000000,
  "n": "com.advert.app",
  "rate": 4.4
 },
 {
  "_id": "56044569703498dd2a524754",
  "cat": "Shopping",
  "dct": 1000000,
  "n": "com.ae.ae",
  "rate": 3.9
 },
 {
  "_id": "56044569703498dd2a52475d",
  "cat": "Arcade",
  "dct": 1000000,
  "n": "com.aemobile.games.luckyfishing",
  "rate": 4.3
 },
 {
  "_id": "56044569703498dd2a524760",
  "cat": "Productivity",
  "dct": 1000000,
  "n": "com.adylitica.android.DoItTomorrow",
  "rate": 4.3
 },
 {
  "_id": "56044569703498dd2a52479d",
  "cat": "Personalization",
  "dct": 1000000,
  "n": "com.afkettler.earth",
  "rate": 4.4
 },
 {
  "_id": "56044569703498dd2a5247ed",
  "cat": "Books & Reference",
  "dct": 1000000,
  "n": "com.agi.android.augmentedreality",
  "rate": 4.1
 },
 {
  "_id": "56044569703498dd2a5247f4",
  "cat": "Shopping",
  "dct": 1000000,
  "n": "com.agilys.myshopi",
  "rate": 4.3
 },
 {
  "_id": "56044569703498dd2a5247ff",
  "cat": "Music & Audio",
  "dct": 1000000,
  "n": "com.agminstruments.drumpadmachine",
  "rate": 4.3
 },
 {
  "_id": "56044569703498dd2a524800",
  "cat": "Music & Audio",
  "dct": 1000000,
  "n": "com.agminstruments.dubstepdrumpadmachine",
  "rate": 4.2
 },
 {
  "_id": "56044569703498dd2a524825",
  "cat": "Educational",
  "dct": 1000000,
  "n": "com.aheadsolutions.hangman",
  "rate": 3.9
 },
 {
  "_id": "56044569703498dd2a52484a",
  "cat": "Racing",
  "dct": 1000000,
  "n": "com.ai.driftzone",
  "rate": 3.9
 },
 {
  "_id": "56044569703498dd2a52484e",
  "cat": "Trivia",
  "dct": 1000000,
  "n": "com.aiadp.resquiz",
  "rate": 3.4
 },
 {
  "_id": "56044569703498dd2a52485f",
  "cat": "Racing",
  "dct": 1000000,
  "n": "com.aim.racinggt",
  "rate": 4
 },
 {
  "_id": "56044569703498dd2a524867",
  "cat": "Racing",
  "dct": 1000000,
  "n": "com.aim.suvrally",
  "rate": 3.8
 },
 {
  "_id": "56044569703498dd2a5248f6",
  "cat": "Entertainment",
  "dct": 1000000,
  "n": "com.ajas.coinflip",
  "rate": 3.8
 },
 {
  "_id": "56044569703498dd2a524912",
  "cat": "Entertainment",
  "dct": 1000000,
  "n": "com.ajramharakh.clashgemcalculator",
  "rate": 3.4
 },
 {
  "_id": "56044569703498dd2a524928",
  "cat": "Books & Reference",
  "dct": 1000000,
  "n": "com.akdevelopment.dict.enmalay.free",
  "rate": 4.2
 },
 {
  "_id": "56044569703498dd2a524937",
  "cat": "Media & Video",
  "dct": 1000000,
  "n": "com.akingi.tc",
  "rate": 3.7
 },
 {
  "_id": "56044569703498dd2a524950",
  "cat": "Personalization",
  "dct": 10

There are 913 apps.

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

Hint: You can use the $regex operator

mongodb query

{"dtp":{"$regex":"September \\d+, 2015"}},{"n":1,"dtp":1}

[
 {
  "_id": "56044568703498dd2a5242db",
  "dtp": "September 1, 2015",
  "n": "com.WildlifePhotoFrames.PhotoFramesAndEffects"
 },
 {
  "_id": "56044568703498dd2a524317",
  "dtp": "September 1, 2015",
  "n": "com.a0soft.gphone.uninstaller"
 },
 {
  "_id": "56044569703498dd2a524587",
  "dtp": "September 1, 2015",
  "n": "com.acc"
 },
 {
  "_id": "56044569703498dd2a52462b",
  "dtp": "September 1, 2015",
  "n": "com.action"
 },
 {
  "_id": "56044569703498dd2a52488e",
  "dtp": "September 1, 2015",
  "n": "com.airhorn.music.app.free.ringtones"
 },
 {
  "_id": "56044569703498dd2a5248cd",
  "dtp": "September 1, 2015",
  "n": "com.airobarogie.dev29.nigeriangospelmusicandartistes"
 },
 {
  "_id": "56044569703498dd2a5249cd",
  "dtp": "September 1, 2015",
  "n": "com.alegre.radio"
 },
 {
  "_id": "56044569703498dd2a524d84",
  "dtp": "September 1, 2015",
  "n": "com.andromo.dev137436.app216675"
 },
 {
  "_id": "56044569703498dd2a524e64",
  "dtp": "September 1, 2015",
  "n": "com.andromo.dev230101.app279706"
 },
 {
  "_id": "56044569703498dd2a524e65",
  "dtp": "September 1, 2015",
  "n": "com.andromo.dev230101.app279721"
 },
 {
  "_id": "56044569703498dd2a525033",
  "dtp": "September 1, 2015",
  "n": "com.andromo.dev34618.app192937"
 },
 {
  "_id": "56044569703498dd2a5250b3",
  "dtp": "September 1, 2015",
  "n": "com.andromo.dev415642.app399075"
 },
 {
  "_id": "56044569703498dd2a5250e9",
  "dtp": "September 1, 2015",
  "n": "com.andromo.dev472678.app430797"
 },
 {
  "_id": "56044571703498dd2a525349",
  "dtp": "September 1, 2015",
  "n": "com.leo.widget.einsteinwidget"
 },
 {
  "_id": "56044572703498dd2a5253f4",
  "dtp": "September 1, 2015",
  "n": "com.life360.android.safetymapd"
 },
 {
  "_id": "56044572703498dd2a525438",
  "dtp": "September 1, 2015",
  "n": "com.lily.times.tweenshusky.all"
 },
 {
  "_id": "56044572703498dd2a52547b",
  "dtp": "September 1, 2015",
  "n": "com.linpusime_tc.android.linpus_tckbd"
 },
 {
  "_id": "56044572703498dd2a5254d7",
  "dtp": "September 1, 2015",
  "n": "com.listia.Listia"
 },
 {
  "_id": "56044572703498dd2a5255e5",
  "dtp": "September 1, 2015",
  "n": "com.locmacau"
 },
 {
  "_id": "56044572703498dd2a525682",
  "dtp": "September 1, 2015",
  "n": "com.lowongan.kerja.indonesia.update"
 },
 {
  "_id": "56044572703498dd2a52598d",
  "dtp": "September 1, 2015",
  "n": "com.my.efrt.special.army.allv1"
 },
 {
  "_id": "56044572703498dd2a525ae6",
  "dtp": "September 1, 2015",
  "n": "com.myyearbook.m"
 },
 {
  "_id": "56044572703498dd2a525c91",
  "dtp": "September 1, 2015",
  "n": "com.pngloop.android"
 },
 {
  "_id": "56044572703498dd2a525d0f",
  "dtp": "September 1, 2015",
  "n": "com.policybazaar"
 },
 {
  "_id": "56044572703498dd2a525f7a",
  "dtp": "September 1, 2015",
  "n": "com.projet.voltaire"
 },
 {
  "_id": "56044572703498dd2a5261b9",
  "dtp": "September 1, 2015",
  "n": "com.samko.controlit"
 },
 {
  "_id": "5604457c703498dd2a526490",
  "dtp": "September 1, 2015",
  "n": "jp.co.transcosmos.TokyoTowerKakurenbo"
 },
 {
  "_id": "5604457c703498dd2a52672e",
  "dtp": "September 1, 2015",
  "n": "jp.stage.music_video_collection_manager_free"
 },
 {
  "_id": "5604457c703498dd2a5267df",
  "dtp": "September 1, 2015",
  "n": "learnersseries.mathematics.trigonometry"
 },
 {
  "_id": "5604457c703498dd2a526845",
  "dtp": "September 1, 2015",
  "n": "litude.radian.cylindercalculator"
 },
 {
  "_id": "5604457c703498dd2a526854",
  "dtp": "September 1, 2015",
  "n": "lk.bhasha.hirunews"
 },
 {
  "_id": "5604457c703498dd2a526d56",
  "dtp": "September 1, 2015",
  "n": "us.pacourts.docket"
 },
 {
  "_id": "56044588703498dd2a527337",
  "dtp": "September 1, 2015",
  "n": "com.jegs.catalog"
 },
 {
  "_id": "56044588703498dd2a5273b5",
  "dtp": "September 1, 2015",
  "n": "com.jimmyinteractive.speed"
 },
 {
  "_id": "56044588703498dd2a527444",
  "dtp": "September 1, 2015",
  "n": "com.joara.mobile"
 },
 {
  "_id": "56044588703498dd2a5275c7",
  "dtp": "September 1, 2015",
  "n": "com.jvckenwood.iheartlink.jvc"
 },
 {
  "_id": "56044588703498dd2a5275c8",
  "dtp": "September 1, 2015",
  "n": "com.jutera.perkprizemob.aphone"
 },
 {
  "_id": "56044588703498dd2a5275cb",
  "dtp": "September 1, 2015",
  "n": "com.jvckenwood.iheartlink.kenwood"
 },
 {
  "_id": "56044588703498dd2a52781b",
  "dtp": "September 1, 2015",
  "n": "com.scanthesun"
 },
 {
  "_id": "56044588703498dd2a5279c1",
  "dtp": "September 1, 2015",
  "n": "com.senecacreeksoftware.fractionalcalculator"
 },
 {
  "_id": "56044588703498dd2a527a4c",
  "dtp": "September 1, 2015",
  "n": "com.sevenitsolutions.biblicalquiz"
 },
 {
  "_id": "56044588703498dd2a527a70",
  "dtp": "September 1, 2015",
  "n": "com.sezapp.tools.tool.box.apps"
 },
 {
  "_id": "56044588703498dd2a527a7c",
  "dtp": "September 1, 2015",
  "n": "com.sfm.jdd"
 },
 {
  "_id": "56044588703498dd2a527e81",
  "dtp": "September 1, 2015",
  "n": "com.sixwaves.strikefleetomega"
 },
 {
  "_id": "56044588703498dd2a527eaa",
  "dtp": "September 1, 2015",
  "n": "com.skava.staplesadvantage.main"
 },

There are 3202 apps