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"
 }
]

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"}, {"t":1, "crt": 1}

[
 {
  "_id": "56044588703498dd2a5272f3",
  "crt": "GO Launcher EX",
  "t": "GO SMS Pro PCastle ThemeEX"
 },
 {
  "_id": "56044588703498dd2a5273cc",
  "crt": "GO Launcher EX",
  "t": "Lock Screen"
 },
 {
  "_id": "56044588703498dd2a5273cd",
  "crt": "GO Launcher EX",
  "t": "Swipe Panel"
 },
 {
  "_id": "56044594703498dd2a5290a6",
  "crt": "GO Launcher EX",
  "t": "GO Battery Saver &Power Widget"
 },
 {
  "_id": "56044594703498dd2a5290a7",
  "crt": "GO Launcher EX",
  "t": "Calendar Panel"
 },
 {
  "_id": "56044594703498dd2a5290ab",
  "crt": "GO Launcher EX",
  "t": "GO Weather Forecast & Widgets"
 },
 {
  "_id": "56044594703498dd2a52911b",
  "crt": "GO Launcher EX",
  "t": "ENJOYLIFE DYNAMIC GOWEATHEREX"
 },
 {
  "_id": "56044594703498dd2a52911c",
  "crt": "GO Launcher EX",
  "t": "Nature Reward Dynamic Weather"
 },
 {
  "_id": "56044594703498dd2a52911e",
  "crt": "GO Launcher EX",
  "t": "Outside GO Weather Widget"
 },
 {
  "_id": "56044594703498dd2a529120",
  "crt": "GO Launcher EX",
  "t": "Taste THEME GO WEATHER EX"
 },
 {
  "_id": "56044594703498dd2a529122",
  "crt": "GO Launcher EX",
  "t": "Penguins Of MG Weather Live BG"
 },
 {
  "_id": "56044594703498dd2a529124",
  "crt": "GO Launcher EX",
  "t": "Elegant Reward Theme GOWeather"
 },
 {
  "_id": "56044594703498dd2a529126",
  "crt": "GO Launcher EX",
  "t": "Default Dynamic1.0 GOWeatherEX"
 },
 {
  "_id": "56044594703498dd2a529133",
  "crt": "GO Launcher EX",
  "t": "Concise white GOWeatherEX"
 },
 {
  "_id": "56044594703498dd2a529135",
  "crt": "GO Launcher EX",
  "t": "MIUI Style GO Weather EX"
 },
 {
  "_id": "56044594703498dd2a5290d5",
  "crt": "GO Launcher EX",
  "t": "GO Launcher EX UI5.0 theme"
 },
 {
  "_id": "56044594703498dd2a529134",
  "crt": "GO Launcher EX",
  "t": "Classic style GOWeatherEX"
 },
 {
  "_id": "56044594703498dd2a529136",
  "crt": "GO Launcher EX",
  "t": "Moon Light GO Weather EX"
 },
 {
  "_id": "56044594703498dd2a529137",
  "crt": "GO Launcher EX",
  "t": "Scenery Weather Widget Theme"
 },
 {
  "_id": "56044594703498dd2a529138",
  "crt": "GO Launcher EX",
  "t": "BlackTransparent GO Widget"
 },
 {
  "_id": "56044594703498dd2a52913d",
  "crt": "GO Launcher EX",
  "t": "Bahasa Indonesian GO WeatherEX"
 },
 {
  "_id": "56044594703498dd2a529127",
  "crt": "GO Launcher EX",
  "t": "Portuguese（Brazilian）GOWeather"
 },
 {
  "_id": "56044594703498dd2a529128",
  "crt": "GO Launcher EX",
  "t": "Romania Language GOWeatherEX"
 },
 {
  "_id": "56044594703498dd2a529129",
  "crt": "GO Launcher EX",
  "t": "Default Dynamic 2.0 GO Weather"
 },
 {
  "_id": "56044594703498dd2a52912a",
  "crt": "GO Launcher EX",
  "t": "DEFAULT DYNAMIC 3.0 GO WEATHER"
 },
 {
  "_id": "56044594703498dd2a52912b",
  "crt": "GO Launcher EX",
  "t": "Slovakia GO Weather EX"
 },
 {
  "_id": "56044594703498dd2a52912c",
  "crt": "GO Launcher EX",
  "t": "Turkish Language GOWeatherEX"
 },
 {
  "_id": "56044594703498dd2a52912d",
  "crt": "GO Launcher EX",
  "t": "Ukrainian Language GOWeatherEX"
 },
 {
  "_id": "56044594703498dd2a52912e",
  "crt": "GO Launcher EX",
  "t": "Vietnamese Language GOWeather"
 },
 {
  "_id": "56044594703498dd2a52912f",
  "crt": "GO Launcher EX",
  "t": "BlackTransparent system widget"
 },
 {
  "_id": "56044594703498dd2a529130",
  "crt": "GO Launcher EX",
  "t": "Blue Gear Theme GO Weather EX"
 },
 {
  "_id": "56044594703498dd2a529131",
  "crt": "GO Launcher EX",
  "t": "Bottle Free Theme GO Weather"
 },
 {
  "_id": "56044594703498dd2a529132",
  "crt": "GO Launcher EX",
  "t": "Concise black GOWeatherEX"
 },
 {
  "_id": "56044594703498dd2a529139",
  "crt": "GO Launcher EX",
  "t": "QuietlyElegant GO Widget Theme"
 },
 {
  "_id": "56044594703498dd2a52913c",
  "crt": "GO Launcher EX",
  "t": "Serbian Language GO Weather EX"
 },
 {
  "_id": "56044594703498dd2a52911a",
  "crt": "GO Launcher EX",
  "t": "Peanuts Weather LiveBackground"
 },
 {
  "_id": "56044594703498dd2a52911f",
  "crt": "GO Launcher EX",
  "t": "Peanuts Weather Widget Theme"
 },
 {
  "_id": "56044594703498dd2a529121",
  "crt": "GO Launcher EX",
  "t": "Unknown Planet Theme GOWeather"
 },
 {
  "_id": "56044594703498dd2a529123",
  "crt": "GO Launcher EX",
  "t": "GRACE THEME GO WEATHER EX"
 },
 {
  "_id": "56044594703498dd2a529125",
  "crt": "GO Launcher EX",
  "t": "VENUS THEME GO WEATHER EX"
 }
]

There are 40 apps.

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

mongodb query

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

[
 {
  "_id": "56044593703498dd2a528d7d",
  "dct": 50000000,
  "t": "Exploration Lite"
 },
 {
  "_id": "56044593703498dd2a528eb1",
  "dct": 50000000,
  "t": "BMX Boy"
 },
 {
  "_id": "56044593703498dd2a528eb4",
  "dct": 50000000,
  "t": "Jewels Star"
 },
 {
  "_id": "56044593703498dd2a528eba",
  "dct": 50000000,
  "t": "Skater Boy"
 },
 {
  "_id": "56044593703498dd2a528f80",
  "dct": 50000000,
  "t": "Ice Age Village"
 },
 {
  "_id": "56044593703498dd2a528f97",
  "dct": 50000000,
  "t": "Spider-Man Unlimited"
 },
 {
  "_id": "56044594703498dd2a529008",
  "dct": 50000000,
  "t": "Walk Band - Music Studio"
 },
 {
  "_id": "56044594703498dd2a5290ab",
  "dct": 50000000,
  "t": "GO Weather Forecast & Widgets"
 },
 {
  "_id": "56044588703498dd2a527e4e",
  "dct": 50000000,
  "t": "Bible"
 },
 {
  "_id": "5604459c703498dd2a529a12",
  "dct": 50000000,
  "t": "GO Keyboard Lite + Emoji"
 },
 {
  "_id": "560445ab703498dd2a52a9ce",
  "dct": 50000000,
  "t": "Brightest Flashlight Free ®"
 },
 {
  "_id": "56044572703498dd2a52566e",
  "dct": 50000000,
  "t": "Zello PTT Walkie Talkie"
 },
 {
  "_id": "56044571703498dd2a52533c",
  "dct": 50000000,
  "t": "SHAREit - Connect & Transfer"
 },
 {
  "_id": "56044571703498dd2a525341",
  "dct": 50000000,
  "t": "LEO Privacy Guard - AppLock"
 },
 {
  "_id": "56044572703498dd2a525b84",
  "dct": 50000000,
  "t": "Pixlr – Free Photo Editor"
 },
 {
  "_id": "56044572703498dd2a525db3",
  "dct": 50000000,
  "t": "myCalendar - Period Tracker"
 },
 {
  "_id": "56044572703498dd2a525ff0",
  "dct": 50000000,
  "t": "Antivirus Booster & Cleaner"
 },
 {
  "_id": "56044588703498dd2a528196",
  "dct": 50000000,
  "t": "ColorNote Notepad Notes"
 },
 {
  "_id": "56044588703498dd2a527abb",
  "dct": 100000000,
  "t": "Tango - Free Video Call & Chat"
 },
 {
  "_id": "56044593703498dd2a528ce6",
  "dct": 100000000,
  "t": "Evernote"
 },
 {
  "_id": "56044593703498dd2a528f76",
  "dct": 100000000,
  "t": "Despicable Me"
 },
 {
  "_id": "5604459c703498dd2a529c81",
  "dct": 100000000,
  "t": "Smart Connect"
 },
 {
  "_id": "56044569703498dd2a5251f6",
  "dct": 100000000,
  "t": "AntiVirus FREE - Security Scan"
 },
 {
  "_id": "56044572703498dd2a52563b",
  "dct": 100000000,
  "t": "Lookout Security & Antivirus"
 },
 {
  "_id": "56044572703498dd2a525986",
  "dct": 100000000,
  "t": "MX Player"
 },
 {
  "_id": "56044572703498dd2a525d10",
  "dct": 100000000,
  "t": "Samsung Security Policy Update"
 },
 {
  "_id": "56044588703498dd2a527918",
  "dct": 100000000,
  "t": "Samsung Print Service Plugin"
 },
 {
  "_id": "56044571703498dd2a52525d",
  "dct": 100000000,
  "t": "Omni Swipe"
 },
 {
  "_id": "56044593703498dd2a528819",
  "dct": 100000000,
  "t": "eBay"
 },
 {
  "_id": "56044588703498dd2a527290",
  "dct": 100000000,
  "t": "GO SMS Pro"
 },
 {
  "_id": "56044593703498dd2a528411",
  "dct": 100000000,
  "t": "Drag Racing"
 },
 {
  "_id": "560445ab703498dd2a52a3a6",
  "dct": 100000000,
  "t": "Super-Bright LED Flashlight"
 },
 {
  "_id": "56044588703498dd2a52791b",
  "dct": 500000000,
  "t": "Samsung Push Service"
 }
]

There are 33 apps.

Hint: the desc field is indexed with a text index. Use the $text operator.

mongodb query

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

[
 {
  "_id": "560445b0703498dd2a52b51b",
  "t": "5S Online: The Movies"
 },
 {
  "_id": "5604457c703498dd2a526807",
  "t": "Ottawa Music ONLINE"
 },
 {
  "_id": "5604457c703498dd2a526804",
  "t": "Athens Music ONLINE"
 },
 {
  "_id": "56044588703498dd2a527495",
  "t": "Jokes in Hindi"
 },
 {
  "_id": "56044572703498dd2a525b3a",
  "t": "Divine Pearls"
 },
 {
  "_id": "5604457c703498dd2a526939",
  "t": "Naats (Audio & Video)"
 },
 {
  "_id": "5604457c703498dd2a526c6a",
  "t": "Traffic Wales Traffig Cymru"
 },
 {
  "_id": "560445b0703498dd2a52b5e8",
  "t": "Sports Highlight Videos"
 },
 {
  "_id": "5604459c703498dd2a529d12",
  "t": "Space War Free"
 },
 {
  "_id": "560445b0703498dd2a52b5f4",
  "t": "Style Zone - Style & Fashion"
 },
 {
  "_id": "5604457c703498dd2a52678a",
  "t": "JumiCam lite"
 },
 {
  "_id": "56044572703498dd2a5260dd",
  "t": "Othaim Markets  - اسواق العثيم"
 },
 {
  "_id": "56044568703498dd2a524371",
  "t": "Anti Inflammation Dieting"
 },
 {
  "_id": "56044593703498dd2a5286b3",
  "t": "Mirror Camera – Twin Effect"
 },
 {
  "_id": "56044593703498dd2a528c6a",
  "t": "Daily News, eBooks & Magazines"
 },
 {
  "_id": "56044569703498dd2a524a8b",
  "t": "AIO Remote"
 },
 {
  "_id": "560445ab703498dd2a52ab34",
  "t": "Shoop! E-Commerce Sell Online"
 },
 {
  "_id": "56044593703498dd2a52871d",
  "t": "Fluffy Heart Pink Love Theme"
 },
 {
  "_id": "56044588703498dd2a527e80",
  "t": "Patient Records Doctor ON GO-T"
 },
 {
  "_id": "56044593703498dd2a528753",
  "t": "Be My Valentine Love Theme"
 },
 {
  "_id": "560445af703498dd2a52b2a8",
  "t": "Shoe Designer Fashion Games 3D"
 },
 {
  "_id": "56044593703498dd2a528737",
  "t": "Pink Love Bear Heart Theme"
 },
 {
  "_id": "56044572703498dd2a525b97",
  "t": "FREE AP World History Review"
 },
 {
  "_id": "56044569703498dd2a524795",
  "t": "Pong Ball Catapult: Target Cup"
 },
 {
  "_id": "56044588703498dd2a527b81",
  "t": "Sherwin Gardner"
 },
 {
  "_id": "5604457c703498dd2a526ff9",
  "t": "Cute Photo Collages Pic Editor"
 },
 {
  "_id": "56044593703498dd2a52874d",
  "t": "Music Record DJ CD Rock Theme"
 },
 {
  "_id": "5604457c703498dd2a5270df",
  "t": "3D Model Dress Up Girl Game"
 },
 {
  "_id": "56044569703498dd2a525048",
  "t": "Yoga"
 },
 {
  "_id": "56044569703498dd2a52499c",
  "t": "Dynamic Keyboard - Free"
 },
 {
  "_id": "5604457c703498dd2a527186",
  "t": "3D Nail Art Games for Girls"
 },
 {
  "_id": "56044593703498dd2a528b70",
  "t": "Scan-2-ID Pill Images from NDC"
 },
 {
  "_id": "56044593703498dd2a528746",
  "t": "Cloudy Grey Galaxy Sky Theme"
 },
 {
  "_id": "56044569703498dd2a524a95",
  "t": "Rumah.com"
 },
 {
  "_id": "5604457c703498dd2a526ff7",
  "t": "Cute Girl Selfie Photo Editor"
 },
 {
  "_id": "56044588703498dd2a527875",
  "t": "Working Scale Free"
 },
 {
  "_id": "56044593703498dd2a5285df",
  "t": "Zero Browser ▌FREE BROWSER"
 },
 {
  "_id": "5604459c703498dd2a529be0",
  "t": "Let's Tarot (Tarot reading)"
 },
 {
  "_id": "56044569703498dd2a524a94",
  "t": "PropertyGuru Malaysia"
 },
 {
  "_id": "56044568703498dd2a52443c",
  "t": "Oilfield and Oil Rig Jobs Tips"
 },
 {
  "_id": "56044593703498dd2a528d15",
  "t": "eWeapons™ Gun Weapon Simulator"
 },
 {
  "_id": "56044588703498dd2a5281b2",
  "t": "Beautiful Italy Live Wallpaper"
 },
 {
  "_id": "56044571703498dd2a52524d",
  "t": "MLA-Indian Central Acts 3.0"
 },
 {
  "_id": "56044572703498dd2a525921",
  "t": "Symphony Music Player Free"
 },
 {
  "_id": "56044572703498dd2a52590b",
  "t": "Muscle Car Digital Magazine"
 },
 {
  "_id": "56044572703498dd2a525bc2",
  "t": "PlanetDroid"
 },
 {
  "_id": "56044572703498dd2a5257db",
  "t": "MRC Global PVF Mobile Handbook"
 },
 {
  "_id": "56044593703498dd2a52875b",
  "t": "Mobogenie Theme（Authorized）"
 },
 {
  "_id": "560445ac703498dd2a52afa4",
  "t": "Heart Balloons Live Wallpaper"
 },
 {
  "_id": "56044588703498dd2a5281ce",
  "t": "Grand Russia Live Wallpaper"
 },
 {
  "_id": "56044593703498dd2a528754",
  "t": "Believe in 2015 Launcher Theme"
 },
 {
  "_id": "56044593703498dd2a528728",
  "t": "Paris Night Eiffel Tower Theme"
 },
 {
  "_id": "56044593703498dd2a528750",
  "t": "Believe Tomorrow Theme"
 },
 {
  "_id": "56044593703498dd2a5288a4",
  "t": "Senerade Topic Launcher Theme"
 },
 {
  "_id": "56044593703498dd2a528752",
  "t": "Complex and Simple Theme"
 },
 {
  "_id": "5604459c703498dd2a529e06",
  "t": "Splashtop Enterprise"
 },
 {
  "_id": "5604457c703498dd2a526b56",
  "t": "ezPDF CLEAR for Redeem Code"
 },
 {
  "_id": "56044572703498dd2a52587e",
  "t": "My Tour Talk"
 },
 {
  "_id": "5604457c703498dd2a527185",
  "t": "Beauty Nail Salon Game"
 },
 {
  "_id": "560445af703498dd2a52b1c4",
  "t": "Perfect Sunrise Live Wallpaper"
 },
 {
  "_id": "56044593703498dd2a5287e6",
  "t": "Easymind - Vote & Decide"
 },
 {
  "_id": "560445ab703498dd2a52a8a9",
  "t": "ViPi Mobile App"
 },
 {
  "_id": "56044572703498dd2a5261be",
  "t": "Little Pony Gallery Wallpapers"
 },
 {
  "_id": "560445af703498dd2a52b1f0",
  "t": "Rare Diamonds Live Wallpaper"
 },
 {

There are 4197 apps.

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"]}}, {"cat": 1, "t":1}

[
 {
  "_id": "56044572703498dd2a52613b",
  "cat": "Business",
  "t": "Safety Notes"
 },
 {
  "_id": "56044572703498dd2a526142",
  "cat": "Business",
  "t": "Sage CRM for Android"
 },
 {
  "_id": "56044572703498dd2a52614d",
  "cat": "Business",
  "t": "sahibinden.com"
 },
 {
  "_id": "56044572703498dd2a526171",
  "cat": "Business",
  "t": "Sakan"
 },
 {
  "_id": "5604457c703498dd2a5263d4",
  "cat": "Business",
  "t": "NIIGATA BIZ EXPO MAP"
 },
 {
  "_id": "5604457c703498dd2a5263dc",
  "cat": "Business",
  "t": "Brightness Scheduler"
 },
 {
  "_id": "5604457c703498dd2a52689d",
  "cat": "Business",
  "t": "LS Retail Loyalty"
 },
 {
  "_id": "5604457c703498dd2a526a3b",
  "cat": "Business",
  "t": "Array VPN"
 },
 {
  "_id": "5604457c703498dd2a526a47",
  "cat": "Business",
  "t": "Artha Timur Property"
 },
 {
  "_id": "5604457c703498dd2a526a4a",
  "cat": "Business",
  "t": "Authorize.Net Mobile POS"
 },
 {
  "_id": "5604457c703498dd2a526a4e",
  "cat": "Business",
  "t": "Fahrschule Ludwig"
 },
 {
  "_id": "5604457c703498dd2a526a78",
  "cat": "Business",
  "t": "Bäckerei Huge"
 },
 {
  "_id": "5604457c703498dd2a526a8a",
  "cat": "Business",
  "t": "Peter Kuhn Hausmeisterservice"
 },
 {
  "_id": "5604457c703498dd2a526a8b",
  "cat": "Business",
  "t": "Hermann Lorenz Rohrleitungsbau"
 },
 {
  "_id": "5604457c703498dd2a526b53",
  "cat": "Business",
  "t": "OnSite Logging HD"
 },
 {
  "_id": "5604457c703498dd2a526c57",
  "cat": "Business",
  "t": "Harding Lewis"
 },
 {
  "_id": "5604457c703498dd2a526d05",
  "cat": "Business",
  "t": "Unison Insurance"
 },
 {
  "_id": "5604457c703498dd2a526d20",
  "cat": "Business",
  "t": "Zjazd PLTR 2013"
 },
 {
  "_id": "5604457c703498dd2a526d22",
  "cat": "Business",
  "t": "E-MRS Meetings"
 },
 {
  "_id": "5604457c703498dd2a526d27",
  "cat": "Business",
  "t": "CMAR Practitioner"
 },
 {
  "_id": "5604457c703498dd2a526d29",
  "cat": "Business",
  "t": "Irwin Insurance Agency"
 },
 {
  "_id": "5604457c703498dd2a526d2a",
  "cat": "Business",
  "t": "Superior Insurance - Salisbury"
 },
 {
  "_id": "5604457c703498dd2a526e9b",
  "cat": "Business",
  "t": "Volume of Tank Calculator Free"
 },
 {
  "_id": "5604457c703498dd2a526e9d",
  "cat": "Business",
  "t": "Pumping power calculator Free"
 },
 {
  "_id": "5604457c703498dd2a526fc4",
  "cat": "Business",
  "t": "AlMarwan Equipment"
 },
 {
  "_id": "5604457c703498dd2a526fd0",
  "cat": "Business",
  "t": "Cheers"
 },
 {
  "_id": "5604457c703498dd2a526fd1",
  "cat": "Business",
  "t": "Haskell’s Wine & Spirits"
 },
 {
  "_id": "5604457c703498dd2a526fd3",
  "cat": "Business",
  "t": "Plymouth Liquor"
 },
 {
  "_id": "5604457c703498dd2a52702b",
  "cat": "Business",
  "t": "Demand Detroit"
 },
 {
  "_id": "5604457c703498dd2a52704c",
  "cat": "Business",
  "t": "Six Sigma Defect Conv Free"
 },
 {
  "_id": "56044588703498dd2a527320",
  "cat": "Business",
  "t": "JDI Backup Affiliates"
 },
 {
  "_id": "56044588703498dd2a527398",
  "cat": "Business",
  "t": "John Henry Foster"
 },
 {
  "_id": "56044588703498dd2a52739b",
  "cat": "Business",
  "t": "Jiang Education Centre"
 },
 {
  "_id": "56044588703498dd2a527445",
  "cat": "Business",
  "t": "Contractor Estimate & Proposal"
 },
 {
  "_id": "56044588703498dd2a527476",
  "cat": "Business",
  "t": "Johan Meure Auto Occasions"
 },
 {
  "_id": "56044588703498dd2a5275a0",
  "cat": "Business",
  "t": "JurFinder lawyer & attorney"
 },
 {
  "_id": "56044588703498dd2a52763b",
  "cat": "Business",
  "t": "Chemical Compatibility"
 },
 {
  "_id": "56044588703498dd2a527697",
  "cat": "Business",
  "t": "San Fernando Valley RE App"
 },
 {
  "_id": "56044588703498dd2a5276b9",
  "cat": "Business",
  "t": "Private Investigator"
 },
 {
  "_id": "56044588703498dd2a5276ba",
  "cat": "Business",
  "t": "Sansan - The Business Card Box"
 },
 {
  "_id": "56044588703498dd2a5276be",
  "cat": "Business",
  "t": "Sanwa Synthetic Opal"
 },
 {
  "_id": "56044588703498dd2a5276c5",
  "cat": "Business",
  "t": "SAP Cloud for Customer"
 },
 {
  "_id": "56044588703498dd2a5276c7",
  "cat": "Business",
  "t": "SAP HR Approvals"
 },
 {
  "_id": "56044588703498dd2a52781d",
  "cat": "Business",
  "t": "ScanBizCards Lite - Scan Card"
 },
 {
  "_id": "56044588703498dd2a5278c9",
  "cat": "Business",
  "t": "Mean Median Mode"
 },
 {
  "_id": "56044588703498dd2a5278cc",
  "cat": "Business",
  "t": "LevelUp Merchant"
 },
 {
  "_id": "56044588703498dd2a52798b",
  "cat": "Business",
  "t": "Seldon.Basis"
 },
 {
  "_id": "56044588703498dd2a52799e",
  "cat": "Business",
  "t": "SellerMobile for Amazon Seller"
 },
 {
  "_id": "56044588703498dd2a5279a4",
  "cat": "Business",
  "t": "Vagaro Pro"
 },
 {
  "_id": "56044588703498dd2a527a84",
  "cat": "Business",
  "t": "Norton Abrasives"
 },
 {
  "_id": "56044588703498dd2a527a88",
  "cat": "Business",
  "t": "Office Renovation Calculator"
 },
 {
  "_id": "56044588703498dd2a527ae8",
  "cat": "Business",
  "t": "POLYMERUPDATE Smart App"
 },
 {
  "_id": "56044588703498dd2a527afd",
  "cat": "Business",

There are 3179 apps.

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}}]}, {"t":1}

[
 {
  "_id": "5604457c703498dd2a526fda",
  "t": "Xray Scan"
 }
]

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= 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": {"$gt": 4}}] }, {"crt": 1, "t": 1}

[
 {
  "_id": "5604459c703498dd2a52988a",
  "crt": "Glu",
  "t": "FRONTLINE COMMANDO: D-DAY"
 },
 {
  "_id": "56044593703498dd2a528f74",
  "crt": "Gameloft",
  "t": "Dungeon Hunter 4"
 },
 {
  "_id": "56044594703498dd2a5290ab",
  "crt": "GO Launcher EX",
  "t": "GO Weather Forecast & Widgets"
 },
 {
  "_id": "56044593703498dd2a528f84",
  "crt": "Gameloft",
  "t": "Ice Age Adventures"
 },
 {
  "_id": "5604457c703498dd2a526687",
  "crt": "LINE Corporation",
  "t": "LINE Pokopang"
 },
 {
  "_id": "56044593703498dd2a528f83",
  "crt": "Gameloft",
  "t": "Blitz Brigade - Online FPS fun"
 },
 {
  "_id": "56044588703498dd2a527877",
  "crt": "SCIMOB",
  "t": "94%"
 },
 {
  "_id": "56044572703498dd2a525b56",
  "crt": "RiliSoft",
  "t": "Pixel Gun 3D"
 },
 {
  "_id": "560445ab703498dd2a52a9ce",
  "crt": "GoldenShores Technologies, LLC",
  "t": "Brightest Flashlight Free ®"
 },
 {
  "_id": "56044593703498dd2a528ce6",
  "crt": "Evernote Corporation",
  "t": "Evernote"
 },
 {
  "_id": "56044593703498dd2a528f82",
  "crt": "Gameloft",
  "t": "Iron Man 3 - The Official Game"
 },
 {
  "_id": "56044593703498dd2a528795",
  "crt": "ELECTRONIC ARTS",
  "t": "SimCity BuildIt"
 },
 {
  "_id": "56044572703498dd2a52545c",
  "crt": "LINE Corporation",
  "t": "LINE Rangers"
 },
 {
  "_id": "56044588703498dd2a527e4e",
  "crt": "LifeChurch.tv",
  "t": "Bible"
 },
 {
  "_id": "56044593703498dd2a528f92",
  "crt": "Gameloft",
  "t": "GT Racing 2: The Real Car Exp"
 },
 {
  "_id": "56044588703498dd2a528196",
  "crt": "Notes",
  "t": "ColorNote Notepad Notes"
 },
 {
  "_id": "56044593703498dd2a528f98",
  "crt": "Gameloft",
  "t": "Six-Guns: Gang Showdown"
 },
 {
  "_id": "5604457c703498dd2a526f2a",
  "crt": "Wattpad.com",
  "t": "Wattpad - Free Books & Stories"
 },
 {
  "_id": "56044593703498dd2a528f7c",
  "crt": "Gameloft",
  "t": "Gangstar Vegas"
 },
 {
  "_id": "56044593703498dd2a528819",
  "crt": "eBay Mobile",
  "t": "eBay"
 },
 {
  "_id": "56044593703498dd2a528f97",
  "crt": "Gameloft",
  "t": "Spider-Man Unlimited"
 },
 {
  "_id": "56044572703498dd2a525eb6",
  "crt": "Pretty Simple",
  "t": "Criminal Case"
 },
 {
  "_id": "56044593703498dd2a528f80",
  "crt": "Gameloft",
  "t": "Ice Age Village"
 },
 {
  "_id": "56044572703498dd2a525ff0",
  "crt": "PSafe Tecnologia S.A.",
  "t": "Antivirus Booster & Cleaner"
 },
 {
  "_id": "560445ab703498dd2a52a88c",
  "crt": "Nordeus",
  "t": "Top Eleven Be a Soccer Manager"
 },
 {
  "_id": "56044572703498dd2a525db3",
  "crt": "ABISHKKING",
  "t": "myCalendar - Period Tracker"
 },
 {
  "_id": "56044593703498dd2a528411",
  "crt": "Creative Mobile",
  "t": "Drag Racing"
 },
 {
  "_id": "56044588703498dd2a527290",
  "crt": "GO Dev Team",
  "t": "GO SMS Pro"
 },
 {
  "_id": "5604459c703498dd2a529a12",
  "crt": "GO Dev Team",
  "t": "GO Keyboard Lite + Emoji"
 },
 {
  "_id": "560445ab703498dd2a52a7b9",
  "crt": "socialpoint",
  "t": "Dragon City"
 },
 {
  "_id": "56044571703498dd2a52525d",
  "crt": "Holaverse Group",
  "t": "Omni Swipe"
 },
 {
  "_id": "560445ac703498dd2a52b137",
  "crt": "Next Floor Corp.",
  "t": "DragonFlight for Kakao"
 },
 {
  "_id": "56044588703498dd2a527abb",
  "crt": "Tango",
  "t": "Tango - Free Video Call & Chat"
 },
 {
  "_id": "56044572703498dd2a525986",
  "crt": "J2 Interactive",
  "t": "MX Player"
 },
 {
  "_id": "56044569703498dd2a5251f6",
  "crt": "AVG Mobile",
  "t": "AntiVirus FREE - Security Scan"
 },
 {
  "_id": "56044593703498dd2a528f6e",
  "crt": "Gameloft",
  "t": "Asphalt 8: Airborne"
 },
 {
  "_id": "560445ab703498dd2a52a3a6",
  "crt": "Surpax Inc.",
  "t": "Super-Bright LED Flashlight"
 },
 {
  "_id": "56044593703498dd2a528f76",
  "crt": "Gameloft",
  "t": "Despicable Me"
 }
]

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

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

[
 {
  "_id": "56044572703498dd2a526175",
  "cat": "Entertainment",
  "t": "Roll and Smoke 3D FREE"
 },
 {
  "_id": "5604457c703498dd2a5262b4",
  "cat": "Simulation",
  "t": "Oriental Bride of the Emperor"
 },
 {
  "_id": "5604457c703498dd2a5262b9",
  "cat": "Simulation",
  "t": "【Arabian Nights Love Story】"
 },
 {
  "_id": "5604457c703498dd2a5263b4",
  "cat": "Arcade",
  "t": "Endless zombie"
 },
 {
  "_id": "5604457c703498dd2a5263d9",
  "cat": "Personalization",
  "t": "ネプテューヌ きせかえっ！無料版"
 },
 {
  "_id": "5604457c703498dd2a52640e",
  "cat": "Entertainment",
  "t": "モンストマルチチャット【マルチ掲示板＆無料チャットアプリ】"
 },
 {
  "_id": "5604457c703498dd2a52644e",
  "cat": "Entertainment",
  "t": "悪用厳禁◆現実100%名前占い【シュメール呪占】"
 },
 {
  "_id": "5604457c703498dd2a526463",
  "cat": "Role Playing",
  "t": "Age of Ishtaria - A.Battle RPG"
 },
 {
  "_id": "5604457c703498dd2a5266f0",
  "cat": "Arcade",
  "t": "ZEN -Crazy Japan Style-"
 },
 {
  "_id": "5604457c703498dd2a5266f3",
  "cat": "Adventure",
  "t": "ホラー脱出ゲーム MT"
 },
 {
  "_id": "5604457c703498dd2a52684a",
  "cat": "Lifestyle",
  "t": "Live Toto Singapore"
 },
 {
  "_id": "5604457c703498dd2a52684d",
  "cat": "Entertainment",
  "t": "Live TV - Watch TV Free"
 },
 {
  "_id": "5604457c703498dd2a526890",
  "cat": "Travel & Local",
  "t": "Lozi - Địa điểm món ăn ngon"
 },
 {
  "_id": "5604457c703498dd2a526892",
  "cat": "Entertainment",
  "t": "X Earn Recharge"
 },
 {
  "_id": "5604457c703498dd2a5268cd",
  "cat": "Puzzle",
  "t": "Escape: The Accusation"
 },
 {
  "_id": "5604457c703498dd2a5268d2",
  "cat": "Adventure",
  "t": "The Escape Game from Hell"
 },
 {
  "_id": "5604457c703498dd2a526a3f",
  "cat": "Social",
  "t": "Ask Me"
 },
 {
  "_id": "5604457c703498dd2a526a47",
  "cat": "Business",
  "t": "Artha Timur Property"
 },
 {
  "_id": "5604457c703498dd2a526a49",
  "cat": "Education",
  "t": "Elizabeth International"
 },
 {
  "_id": "5604457c703498dd2a526c83",
  "cat": "Lifestyle",
  "t": "Prayers & Blessings Daily"
 },
 {
  "_id": "5604457c703498dd2a526c84",
  "cat": "Lifestyle",
  "t": "Uplifting Psalms Daily"
 },
 {
  "_id": "5604457c703498dd2a526d2b",
  "cat": "Tools",
  "t": "Lottery Formula (Lotto expert)"
 },
 {
  "_id": "5604457c703498dd2a526d30",
  "cat": "Lifestyle",
  "t": "Nouvelle proverbe amour"
 },
 {
  "_id": "5604457c703498dd2a526d8f",
  "cat": "Lifestyle",
  "t": "Horror Sounds"
 },
 {
  "_id": "5604457c703498dd2a526e25",
  "cat": "Card",
  "t": "Xam Loc - Sam Loc"
 },
 {
  "_id": "5604457c703498dd2a526e28",
  "cat": "Card",
  "t": "Tien Len Mien Nam"
 },
 {
  "_id": "5604457c703498dd2a526e32",
  "cat": "Education",
  "t": "STEM.VN"
 },
 {
  "_id": "5604457c703498dd2a526e39",
  "cat": "Lifestyle",
  "t": "Dear Future Me"
 },
 {
  "_id": "5604457c703498dd2a526ebc",
  "cat": "Social",
  "t": "PTT~NOW!"
 },
 {
  "_id": "5604457c703498dd2a526ec4",
  "cat": "Sports",
  "t": "Why Always Bet 2.0 Betting Tip"
 },
 {
  "_id": "5604457c703498dd2a526f26",
  "cat": "Books & Reference",
  "t": "Bestof World's Funniest Quotes"
 },
 {
  "_id": "5604457c703498dd2a526f2a",
  "cat": "Books & Reference",
  "t": "Wattpad - Free Books & Stories"
 },
 {
  "_id": "5604457c703498dd2a526f4e",
  "cat": "Casual",
  "t": "Stun Shock Weapon"
 },
 {
  "_id": "5604457c703498dd2a526fc9",
  "cat": "Adventure",
  "t": "Real Hang Gliding : Free Game"
 },
 {
  "_id": "5604457c703498dd2a526fd9",
  "cat": "Casual",
  "t": "Xray Prank"
 },
 {
  "_id": "5604457c703498dd2a527092",
  "cat": "Personalization",
  "t": "Predator Clock"
 },
 {
  "_id": "5604457c703498dd2a5270a4",
  "cat": "Role Playing",
  "t": "Across Age 2"
 },
 {
  "_id": "5604457c703498dd2a527169",
  "cat": "Action",
  "t": "Commando Helicopter War"
 },
 {
  "_id": "5604457c703498dd2a5271aa",
  "cat": "Simulation",
  "t": "可愛すぎる美少女育成★【ソウルガール】GooglePlay版"
 },
 {
  "_id": "56044588703498dd2a52723e",
  "cat": "Personalization",
  "t": "Black Widow Keyboard Theme"
 },
 {
  "_id": "56044588703498dd2a52730b",
  "cat": "Trivia",
  "t": "Fanquiz for Game of Thrones"
 },
 {
  "_id": "56044588703498dd2a52743a",
  "cat": "Casual",
  "t": "Mean Life Coach"
 },
 {
  "_id": "56044588703498dd2a52743d",
  "cat": "Entertainment",
  "t": "Just Odds"
 },
 {
  "_id": "56044588703498dd2a527466",
  "cat": "Productivity",
  "t": "Joel Mone Blog"
 },
 {
  "_id": "56044588703498dd2a52746f",
  "cat": "Travel & Local",
  "t": "Foursquare - Best City Guide"
 },
 {
  "_id": "56044588703498dd2a527475",
  "cat": "Simulation",
  "t": "VTC Driver : Private Taxi"
 },
 {
  "_id": "56044588703498dd2a5274cc",
  "cat": "Lifestyle",
  "t": "Meditation (Lets Compete)"
 },
 {
  "_id": "56044588703498dd2a5275a0",
  "cat": "Business",
  "t": "JurFinder lawyer & attorney"
 },
 {
  "_id": "56044588703498dd2a52783e",
  "cat": "Simulation",
  "t": "Face Scanner: Vampire Monster"
 },
 {
  "_id": "56044588703498dd2a52789c",
  "cat": "Social",
  "t": "ScorePointer"
 },
 {
  "_id": "56044588703498dd2a5278d3",
  "cat": "Entertainment",
  "t": "Discothek Brooklyn"
 },
 {
  "_id": "56044588703498

There are 1763 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}}]}, 
{"t": 1, "cat": 1, "dct": 1, "rate": 1}

[
 {
  "_id": "56044593703498dd2a528f76",
  "cat": "Casual Action & Adventure",
  "dct": 100000000,
  "rate": 4.4,
  "t": "Despicable Me"
 },
 {
  "_id": "56044593703498dd2a528f80",
  "cat": "Casual",
  "dct": 50000000,
  "rate": 4.4,
  "t": "Ice Age Village"
 }
]

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

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

[
 {
  "_id": "5604459c703498dd2a529890",
  "curl": "/store/apps/dev?id=8633921029894576093",
  "t": "ETERNITY WARRIORS 2"
 },
 {
  "_id": "5604459c703498dd2a529893",
  "curl": "/store/apps/dev?id=8633921029894576093",
  "t": "SAMURAI vs ZOMBIES DEFENSE"
 },
 {
  "_id": "56044593703498dd2a528dfc",
  "curl": "/store/apps/developer?id=Ezone.com",
  "t": "Diversion"
 },
 {
  "_id": "5604459c703498dd2a52988c",
  "curl": "/store/apps/dev?id=8633921029894576093",
  "t": "BLOOD & GLORY: LEGEND"
 },
 {
  "_id": "5604459c703498dd2a529dda",
  "curl": "/store/apps/developer?id=Spil+Games",
  "t": "My Dolphin Show"
 },
 {
  "_id": "560445ac703498dd2a52ade5",
  "curl": "/store/apps/developer?id=IODEMA+Srl",
  "t": "ElectroDroid"
 },
 {
  "_id": "5604457c703498dd2a526263",
  "curl": "/store/apps/developer?id=Salem+Web+Network",
  "t": "Daily Bible"
 },
 {
  "_id": "56044594703498dd2a52901a",
  "curl": "/store/apps/dev?id=8370361226290054499",
  "t": "Cartoon Wars: Gunner+"
 },
 {
  "_id": "5604459c703498dd2a52a07b",
  "curl": "/store/apps/developer?id=Strava+Inc.",
  "t": "Strava Running and Cycling GPS"
 },
 {
  "_id": "5604457c703498dd2a526a46",
  "curl": "/store/apps/developer?id=Audiko",
  "t": "Audiko ringtones"
 },
 {
  "_id": "56044588703498dd2a527892",
  "curl": "/store/apps/developer?id=365Scores",
  "t": "Football Scores - 365Scores"
 },
 {
  "_id": "5604459c703498dd2a52988b",
  "curl": "/store/apps/dev?id=8633921029894576093",
  "t": "BLOOD & GLORY"
 },
 {
  "_id": "560445ab703498dd2a52a935",
  "curl": "/store/apps/developer?id=GasBuddy.com",
  "t": "GasBuddy - Find Cheap Gas"
 },
 {
  "_id": "56044588703498dd2a527a5c",
  "curl": "/store/apps/dev?id=6361261091326496818",
  "t": "Paradise Island"
 },
 {
  "_id": "560445ac703498dd2a52b137",
  "curl": "/store/apps/developer?id=Next+Floor+Corp.",
  "t": "DragonFlight for Kakao"
 },
 {
  "_id": "56044588703498dd2a527e4e",
  "curl": "/store/apps/developer?id=LifeChurch.tv",
  "t": "Bible"
 },
 {
  "_id": "560445ab703498dd2a52a9ce",
  "curl": "/store/apps/developer?id=GoldenShores+Technologies,+LLC",
  "t": "Brightest Flashlight Free ®"
 },
 {
  "_id": "56044572703498dd2a525db3",
  "curl": "/store/apps/developer?id=ABISHKKING",
  "t": "myCalendar - Period Tracker"
 },
 {
  "_id": "56044593703498dd2a528ce6",
  "curl": "/store/apps/developer?id=Evernote+Corporation",
  "t": "Evernote"
 }
]

There are 19 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": [{"dct": {"$gt": 1000000}}, {"purl": {"$eq": ""}}]},
{"t": 1, "cat": 1, "dct": 1, "rate": 1}

[
 {
  "_id": "5604457c703498dd2a526372",
  "cat": "Casual",
  "dct": 5000000,
  "rate": 4.4,
  "t": "Mushroom Garden"
 },
 {
  "_id": "5604457c703498dd2a526373",
  "cat": "Casual",
  "dct": 5000000,
  "rate": 4.4,
  "t": "Mushroom Garden Seasons"
 },
 {
  "_id": "5604457c703498dd2a526377",
  "cat": "Personalization",
  "dct": 5000000,
  "rate": 4.3,
  "t": "Desktop VisualizeR"
 },
 {
  "_id": "5604457c703498dd2a52694f",
  "cat": "Personalization",
  "dct": 5000000,
  "rate": 4,
  "t": "Storm (Live wallpaper)"
 },
 {
  "_id": "5604457c703498dd2a526e2a",
  "cat": "Photography",
  "dct": 5000000,
  "rate": 3.4,
  "t": "body symbol"
 },
 {
  "_id": "56044588703498dd2a5273cc",
  "cat": "Productivity",
  "dct": 5000000,
  "rate": 3.9,
  "t": "Lock Screen"
 },
 {
  "_id": "56044588703498dd2a527902",
  "cat": "Photography",
  "dct": 5000000,
  "rate": 4,
  "t": "Photo Collage Art"
 },
 {
  "_id": "56044593703498dd2a5286be",
  "cat": "Puzzle",
  "dct": 5000000,
  "rate": 3.7,
  "t": "Cut and Slice"
 },
 {
  "_id": "56044593703498dd2a528896",
  "cat": "Photography",
  "dct": 5000000,
  "rate": 4.1,
  "t": "Edit images and writing on img"
 },
 {
  "_id": "56044593703498dd2a528e5a",
  "cat": "Racing",
  "dct": 5000000,
  "rate": 4.1,
  "t": "Trial Xtreme 2 Racing Sport 3D"
 },
 {
  "_id": "56044593703498dd2a528eb2",
  "cat": "Casual",
  "dct": 5000000,
  "rate": 4.2,
  "t": "Bubble Totem"
 },
 {
  "_id": "56044594703498dd2a5290b7",
  "cat": "Productivity",
  "dct": 5000000,
  "rate": 4.1,
  "t": "GO Note Widget"
 },
 {
  "_id": "56044594703498dd2a52919c",
  "cat": "Card",
  "dct": 5000000,
  "rate": 4.2,
  "t": "Texas Holdem Poker"
 },
 {
  "_id": "5604459c703498dd2a529bc4",
  "cat": "Tools",
  "dct": 5000000,
  "rate": 3.8,
  "t": "App Lock (Scanner Simulator)"
 },
 {
  "_id": "5604459c703498dd2a529bc5",
  "cat": "Casual",
  "dct": 5000000,
  "rate": 3.4,
  "t": "Lie Detector Voice - Simulator"
 },
 {
  "_id": "5604459c703498dd2a529bc6",
  "cat": "Casual",
  "dct": 5000000,
  "rate": 3.4,
  "t": "Personality Detector Prank"
 },
 {
  "_id": "5604459c703498dd2a529c7e",
  "cat": "Personalization",
  "dct": 5000000,
  "rate": 4.2,
  "t": "Digital Clock Widget Xperia"
 },
 {
  "_id": "5604459c703498dd2a529f2f",
  "cat": "Photography",
  "dct": 5000000,
  "rate": 3.9,
  "t": "EDIT PHOTO WITH SQUARE FRAME"
 },
 {
  "_id": "5604459d703498dd2a52a0fe",
  "cat": "Photography",
  "dct": 5000000,
  "rate": 4,
  "t": "Billboard Photo Frames"
 },
 {
  "_id": "560445ab703498dd2a52a6a5",
  "cat": "Casual",
  "dct": 5000000,
  "rate": 3.5,
  "t": "Electric Screen Colorful Prank"
 },
 {
  "_id": "560445ab703498dd2a52a784",
  "cat": "Puzzle",
  "dct": 5000000,
  "rate": 3.9,
  "t": "Hangman for Spanish learners"
 },
 {
  "_id": "560445ab703498dd2a52a790",
  "cat": "Sports",
  "dct": 5000000,
  "rate": 4.3,
  "t": "LaLiga - Official App"
 },
 {
  "_id": "560445ab703498dd2a52aae4",
  "cat": "Strategy",
  "dct": 5000000,
  "rate": 4.4,
  "t": "Empire Defense II"
 },
 {
  "_id": "56044569703498dd2a52456d",
  "cat": "Casual",
  "dct": 5000000,
  "rate": 3.8,
  "t": "Glow Nails: Manicure Games™"
 },
 {
  "_id": "56044569703498dd2a52486b",
  "cat": "Music & Audio",
  "dct": 5000000,
  "rate": 4.5,
  "t": "AIMP"
 },
 {
  "_id": "56044569703498dd2a524b9b",
  "cat": "Action",
  "dct": 5000000,
  "rate": 3.8,
  "t": "hunting Jungle Animals"
 },
 {
  "_id": "56044572703498dd2a525597",
  "cat": "Tools",
  "dct": 5000000,
  "rate": 4.3,
  "t": "Lock Screen - Iphone Lock"
 },
 {
  "_id": "56044572703498dd2a525930",
  "cat": "Lifestyle",
  "dct": 5000000,
  "rate": 4.4,
  "t": "Prayer times: Qibla & Azan"
 },
 {
  "_id": "56044572703498dd2a525c7d",
  "cat": "Arcade",
  "dct": 5000000,
  "rate": 4.4,
  "t": "GUN ZOMBIE : HELLGATE"
 },
 {
  "_id": "56044572703498dd2a5261c5",
  "cat": "Media & Video",
  "dct": 5000000,
  "rate": 3.6,
  "t": "Remote for Samsung TV"
 },
 {
  "_id": "5604457c703498dd2a526655",
  "cat": "Personalization",
  "dct": 5000000,
  "rate": 3.9,
  "t": "Device Info Live WallPaper"
 },
 {
  "_id": "5604457c703498dd2a526fb2",
  "cat": "Productivity",
  "dct": 5000000,
  "rate": 4.4,
  "t": "File Expert with Clouds"
 },
 {
  "_id": "56044588703498dd2a52728f",
  "cat": "Personalization",
  "dct": 5000000,
  "rate": 3.3,
  "t": "GO SMS PRO EMOJI PLUGIN"
 },
 {
  "_id": "56044588703498dd2a52748c",
  "cat": "Casual",
  "dct": 5000000,
  "rate": 3.1,
  "t": "X-Ray Droid Scanner"
 },
 {
  "_id": "56044588703498dd2a527aad",
  "cat": "Word",
  "dct": 5000000,
  "rate": 4.4,
  "t": "4 Pics 1 Word Puzzle Plus"
 },
 {
  "_id": "56044588703498dd2a528041",
  "cat": "Tools",
  "dct": 5000000,
  "rate": 4.1,
  "t": "WiFi File Transfer"
 },
 {
  "_id": "56044588703498dd2a52813f",
  "cat": "Arcade",
  "dct": 5000000,
  "rate": 3.9,
  "t": "Sniper & Killer 3D"
 },
 {
  "_id": "56044593703498dd2a528601",
  "cat": "Photography",
  "dct": 5000000,
  "rate": 3.7,
  "t": "Change Hair And Eye Color"
 },
 {
  "_id": "56044593703498dd2a52860c",
  "cat": "Arcade"

There are 191 apps.

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

Hint: You can use the $regex operator

mongodb query

{"$or": [
    {"dtp": {"$regex": "September .*, 2015"}},
    {"desc": {"$regex": "September .*, 2015"}}]}, 
{"t": 1, "dtp": 1}

[
 {
  "_id": "56044572703498dd2a52614d",
  "dtp": "September 14, 2015",
  "t": "sahibinden.com"
 },
 {
  "_id": "56044572703498dd2a52617d",
  "dtp": "September 16, 2015",
  "t": "Dhammapada Indonesia"
 },
 {
  "_id": "56044572703498dd2a5261b9",
  "dtp": "September 1, 2015",
  "t": "Control It – Remotes Unified!"
 },
 {
  "_id": "56044572703498dd2a5261e3",
  "dtp": "September 19, 2015",
  "t": "Computer Awareness quiz"
 },
 {
  "_id": "56044572703498dd2a5261e5",
  "dtp": "September 16, 2015",
  "t": "APSC (Assam PSC)"
 },
 {
  "_id": "5604457c703498dd2a52636b",
  "dtp": "September 7, 2015",
  "t": "Drop Eraser"
 },
 {
  "_id": "5604457c703498dd2a526374",
  "dtp": "September 10, 2015",
  "t": "NEO Mushroom Garden"
 },
 {
  "_id": "5604457c703498dd2a526394",
  "dtp": "September 6, 2015",
  "t": "脱出ゲーム 南の海のサンタさん～MILD ESCAPE～"
 },
 {
  "_id": "5604457c703498dd2a526395",
  "dtp": "September 6, 2015",
  "t": "脱出ゲーム バンガローからの脱出～MILD ESCAPE～"
 },
 {
  "_id": "5604457c703498dd2a526396",
  "dtp": "September 10, 2015",
  "t": "Midnight Cinderella:Otome Game"
 },
 {
  "_id": "5604457c703498dd2a5263a2",
  "dtp": "September 15, 2015",
  "t": "Schedule St.(Free Day Planner)"
 },
 {
  "_id": "5604457c703498dd2a5263a8",
  "dtp": "September 18, 2015",
  "t": "StampFriends -free cute stamps"
 },
 {
  "_id": "5604457c703498dd2a5263ad",
  "dtp": "September 7, 2015",
  "t": "Sleipnir Mobile Test Version"
 },
 {
  "_id": "5604457c703498dd2a5263af",
  "dtp": "September 17, 2015",
  "t": "Flash Selfie"
 },
 {
  "_id": "5604457c703498dd2a5263cf",
  "dtp": "September 15, 2015",
  "t": "Mags Inc.[Collage+PhotoBook]"
 },
 {
  "_id": "5604457c703498dd2a5263e3",
  "dtp": "September 19, 2015",
  "t": "2級ボイラー技士問題集ー体験版ー　りすさんシリーズ"
 },
 {
  "_id": "5604457c703498dd2a526403",
  "dtp": "September 2, 2015",
  "t": "Monster Strike"
 },
 {
  "_id": "5604457c703498dd2a526407",
  "dtp": "September 7, 2015",
  "t": "KAGOSHIMA Sights"
 },
 {
  "_id": "5604457c703498dd2a52640d",
  "dtp": "September 12, 2015",
  "t": "Monochrome Color(PhotoEffects)"
 },
 {
  "_id": "5604457c703498dd2a526449",
  "dtp": "September 9, 2015",
  "t": "OshareWeather - For cute girls"
 },
 {
  "_id": "5604457c703498dd2a526456",
  "dtp": "September 10, 2015",
  "t": "Hello Kitty Which One?"
 },
 {
  "_id": "5604457c703498dd2a526475",
  "dtp": "September 18, 2015",
  "t": "PlayMemories Online"
 },
 {
  "_id": "5604457c703498dd2a526511",
  "dtp": "September 4, 2015",
  "t": "Geinou News Headline Widget"
 },
 {
  "_id": "5604457c703498dd2a526512",
  "dtp": "September 13, 2015",
  "t": "カップル専用アプリCouples(カップルズ)恋人思い出共有"
 },
 {
  "_id": "5604457c703498dd2a52651a",
  "dtp": "September 23, 2015",
  "t": "ForkHub for GitHub"
 },
 {
  "_id": "5604457c703498dd2a526589",
  "dtp": "September 17, 2015",
  "t": "HAPPINESS CAM"
 },
 {
  "_id": "5604457c703498dd2a5265d1",
  "dtp": "September 17, 2015",
  "t": "ZOOKEEPER BATTLE"
 },
 {
  "_id": "5604457c703498dd2a52666e",
  "dtp": "September 10, 2015",
  "t": "Temperature humidity barometeF"
 },
 {
  "_id": "5604457c703498dd2a5266d4",
  "dtp": "September 11, 2015",
  "t": "MERY［メリー］- 女の子のための無料まとめアプリ"
 },
 {
  "_id": "5604457c703498dd2a5266f0",
  "dtp": "September 3, 2015",
  "t": "ZEN -Crazy Japan Style-"
 },
 {
  "_id": "5604457c703498dd2a5266f1",
  "dtp": "September 15, 2015",
  "t": "pixiv"
 },
 {
  "_id": "5604457c703498dd2a52672e",
  "dtp": "September 1, 2015",
  "t": "CD/DVD整理棚 無料版"
 },
 {
  "_id": "5604457c703498dd2a526838",
  "dtp": "September 22, 2015",
  "t": "Línea Verde"
 },
 {
  "_id": "5604457c703498dd2a526843",
  "dtp": "September 18, 2015",
  "t": "Cone Volume Calculator"
 },
 {
  "_id": "5604457c703498dd2a526844",
  "dtp": "September 16, 2015",
  "t": "Area, Perimeter, Circumference"
 },
 {
  "_id": "5604457c703498dd2a526845",
  "dtp": "September 1, 2015",
  "t": "Cylinder Calculator"
 },
 {
  "_id": "5604457c703498dd2a526846",
  "dtp": "September 17, 2015",
  "t": "Specific Gravity"
 },
 {
  "_id": "5604457c703498dd2a526848",
  "dtp": "September 15, 2015",
  "t": "Pressure Conversion Calculator"
 },
 {
  "_id": "5604457c703498dd2a526850",
  "dtp": "September 6, 2015",
  "t": "Football Livescore Widget"
 },
 {
  "_id": "5604457c703498dd2a526890",
  "dtp": "September 6, 2015",
  "t": "Lozi - Địa điểm món ăn ngon"
 },
 {
  "_id": "5604457c703498dd2a52689d",
  "dtp": "September 8, 2015",
  "t": "LS Retail Loyalty"
 },
 {
  "_id": "5604457c703498dd2a5268d3",
  "dtp": "September 14, 2015",
  "t": "Escape: The Giant Chimney"
 },
 {
  "_id": "5604457c703498dd2a526a40",
  "dtp": "September 22, 2015",
  "t": "Guia Fernando de Noronha - PE"
 },
 {
  "_id": "5604457c703498dd2a526a46",
  "dtp": "September 23, 2015",
  "t": "Audiko ringtones"
 },
 {
  "_id": "5604457c703498dd2a526a48",
  "dtp": "September 3, 2015",
  "t": "AudioPocket 2 (BETA)"
 },
 {
  "_id": "5604457c703498dd2a526a4b",
  "dtp": "September 3, 2015",
  "t": "BI-App"
 },
 {
  "_id": "5604457c703498dd2a526a5b",
  "dtp": "September 21, 2015",
  "t": "Athlon Germany GmbH"
 },
 {

There are 3203 apps

book

Mongodb Drills

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

mongodb query

2- How many apps developed by GO Launcher EX?

mongodb query

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

mongodb query

4- How many apps have the word "share" in their description?

mongodb query

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

mongodb query

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

mongodb query

7- Find the title and creator of apps that have been rated above 4 stars by 1,000,000 or more users?

mongodb query

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

mongodb query

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

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?

mongodb query

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

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

mongodb query