Mongodb Drills

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

{"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?

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

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

There are 40 apps.

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

{"dct": {"$gt":10000000}}

[
 {
  "_id": "56044572703498dd2a525b84",
  "cadd": "111 McInnis Parkway\nSan Rafael, California 94903",
  "cat": "Photography",
  "crat": "Everyone",
  "crt": "Autodesk Inc.",
  "curl": "/store/apps/dev?id=6418760394979464117",
  "dct": 50000000,
  "desc": "Pixlr (formerly Pixlr Express) is a fun and powerful photo editor that lets you quickly crop, rotate, and fine-tune any picture. Choose from over 2 million combinations of free effects, overlays, and borders to further personalize your image. Pixlr makes you look like a pro, even if you’ve never edited a photo before.  Create a free Pixlr account to automatically unlock premium content and features including Double Exposure with blend modes and Auto Contrast.  Features: •\tApply effects in real time – preview effects and overlays straight from your camera. •\tEasily crop, rotate and adjust images when saving and sharing.  •\tChoose from four pre-defined dimensions (or input your own custom dimensions) for fast and flexible image resizing after editing.  •\tCreate and customize a photo collage by editing its layout, background, and spacing.  •\t ‘Auto Fix’ photos for a one-click fix to balance out colors, adjusting for poor lighting conditions. •\tExplore cool tools: easily adjust the contrast and brightness of your image, focus on one color with Color Splash, or add impact with Focal Blur.  •\tMake your photo look like a drawing or sketch with stylize adjustments such as halftone, watercolor, and pencil. •\tRemove red-eye and whiten teeth with simple tools. •\tExplore the growing catalog of additional effects, overlays, and border packs. •\tOverlays help adjust the mood of the photo – amplify the tone, cool it down, or add surreal shades. •\tFinish off your editing process with the right border – pick a style that fits you. •\tKeep track of your favorite effects and overlays with the favorites button.  •\tShare your photo directly with friends through Instagram, Facebook, Twitter, or email. Please continue to tell us what you think about Pixlr by leaving a review here in the Google Play Store or contacting us via Twitter (@Pixlr), Facebook (/Pixlr), or Instagram (@pixlr).",
  "dtp": "July 30, 2015",
  "dtxt": "50,000,000 - 100,000,000",
  "n": "com.pixlr.express",
  "new": "v2.6.1 - Google Chromecast support - cast Pixlr from your phone or tablet to your TV. - Fixed the issue with not being able to sign up/sign in. - We squashed a few bugs in this release to make your photo editing experience even better.",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.autodesk.com/privacy&sa=D&usg=AFQjCNEqSFxFNos5kx46CN6eX5pXEMRIqQ",
  "rate": 4.4,
  "rct": 932870,
  "sz": "Varies with device",
  "t": "Pixlr – Free Photo Editor",
  "verc": "4223",
  "id": "com.pixlr.express-4223"
 },
 {
  "_id": "56044572703498dd2a525ff0",
  "cadd": "",
  "cat": "Tools",
  "crat": "Everyone",
  "crt": "PSafe Tecnologia S.A.",
  "curl": "/store/apps/developer?id=PSafe+Tecnologia+S.A.",
  "dct": 50000000,
  "desc": "Antivirus, Booster & Cleaner Description PSafe Total keeps your Android™ safe and optimized to run fast.  It is a fully-featured, free antivirus, and leaves your smartphone safe, clean, and fast (like it used to be). If you have an Android phone: You want  PROTECTION, AVAILABLE MEMORY, SPEED, PERFORMANCE, PRIVACY, HIGH CONTROL & EASE OF USE. You get  FREE ANTIVIRUS, MEMORY CLEANER, BOOSTER, APP-LOCK VAULT, ANTITHEFT AND MUCH MORE. More than 50 million downloads of the #1 Brazilian app in the Play Store.  100% free and recognized a leader by AV-TEST , the leading international certifier in the fields of IT security  and smartphone antivirus performance. Improve your Android with a little help from PSafe. PSafe Total cleans and accelerates your smartphone, and protects it at the same time! MAIN FEATURES OF PSAFE TOTAL Antivirus:  real-time protection and the largest antivirus base to combat digital threats in Latin America. Everything you need to keep your Android safe, protected against malicious activities, andfree from virus, malware, or spyware. Cleanup:  removal of junk files that compromise the phone's performance. PSafe Total cleans your cache and temporary files, and even lets you  delete pre-installed applications – freeing up internal memory and SD card space to fit  new Apps, photos and videos. Booster:  Optimizes performance to make your Android faster. Speed up your mobile and free up RAM with just one click, througha convenient “floating window” on the home screen. Vault:  unbeatable app-lock protection to enhance the privacy of your personal information. Lock your applications, photos, SMS, calendar, orcontacts with a second password, even if the device itself is left unlocked. Anti-theft:  Locate,track and manage your device from anywhere through PSafe Total’s convenient web interface. In case of loss or theft, you can block access and functions, wipe your data, and even disable the phone. Other features:  Veri

(answer) There are 33 app

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.

{"$text":{"$search": "share"}}

[
 {
  "_id": "5604457c703498dd2a526807",
  "cadd": "",
  "cat": "Music & Audio",
  "crat": "Everyone",
  "crt": "LEX Andra",
  "curl": "/store/apps/developer?id=LEX+Andra",
  "dct": 100,
  "desc": "Ottawa Music in HQ format. Download and enjoy the world of Music! This is a collection of Ottawa Music channels. Free Internet Radio Stations. Listen to all of the best Ottawa Radios!  - refresh list of streams - internet connexion starting with 24 Kbit/sec - instant Track Info - share button - most popular channels Receive a call and the radio is automatically off! Only the original broadcast with highest quality! Please use a fast internet connection for top app performance. If you find errors, please report and we will refresh the channels. We offer 24 hour customer support! KCRS - Kamloops Classic Rock Station Rythme FM 100.1 Mauricie 102.3 The Bear CJWW 600 CKZW 1650 AM RDI le Reseau de l'Information The Island FM 100.7 Quebec Country The Tide 98.1 FM KG Country 95.5 FM Voices 4 Ability Radio Niagara Funny 820 AM Pure Rock Radio Crystal Radio CKVM 93.1 FM Quebec Radio FM Espace Musique Toronto CKWY Wayne 93.7 FM The Goat K93 FM Ancient FM Bandle City Radio Magic 97.1 FM Swisssh Holiday Radio QC La Tuque 97.1 CFLM Star 94.7 CKLF Fred FM 92.3 The Wave 97.3 FM Broken Neck Radio Swisssh Radio Drunk.FM 89.5 The Lake Retro Souvenirs Voiceprint Canada CHOC FM 104.9 Sun FM 99.9 CPAM 1610 AM Moose CFBG FM 99.5 NRJ Val-d'Or 102.7 Planete 93.5 Planete 96.5 Hairball Canada ARMOR-RADIO.COM DRUM FM Claude For Ever MIX 96.5 FM Soundraum-Radio The EP Express Elvis Gold CITI 92 FM CO-OP Radio CFRO 100.5 FM Resplandece 94.3 The Goat AnimeNfo Radio Bob FM 103.7 105.1 Ed FM The Bounce 91.7 FM Funny 1410 AM Crucial Velocity Radio CJTR 91.3 FM 89 X FM Juice FM 103.5 FM CJLO 1690 AM laut.fm Shout-FM 1050 CJNB Z 98.9 CJAD 800 AM 93.5 Prairie FM Q 98 Dove Radio HOT105.7 iSpinLive Radio Techno FM Live CYUL Montreal ATC MIX 104 CKXD K Rock 98.7 FM 100.9 Canoe FM Power 99 FM Radio Ville Marie Eternal Gospel Radio Planète Lov' 102.1 NRJ Estrie 106.1 FM 2Day FM 101.1 The Port 1240 AM Kiss 92.5 Radio Humsafar Boom 97.3 FM Family Radio CHRI 99.1 FM Sikh Kirtan Radio Rendezvous Radio Rock 106.1 FM VM Radio Roots CHYZ 94.3 FM VOCM 650 AM Pur FM 94.1 94 Ottawa's New Country Hot 105.5 CIUT 89.5 FM 97.9 The Range SUN COUNTRY Calm Radio - Yo-Yo Ma Awesome 100 FM Classic Rock 95.7 Capitale Radio CKJH - Oldies! CK 750 AM Sun FM 97.1 LTD Radio Q104 Classical 103.1 CJVR FM Country AM 800 CKLW KYQ 95.7 FM The Haze FM Country 92.9 LU Radio 102.7 FM Sun FM 105.7 The Farm 101.1 FM Techno FM Techno 93.1 Chay Today The Boss Radio - Dance 102.9 K-Lite Calm Radio - Wagner Scratch Radio Rock 107 Sonic 104.9 The Wolf 100.3 FM Calm Radio - Zen News Talk 980 CJME Belleterre Radio 2 CAM-FM 98.1 96.1 BOB FM EZ Rock 101.5 M 103.5 FM KNR PodRadio Alpha HNE LoveHits.net CJSW 90.9 FM Paradise-Webradio PE Irish Radio Sun FM 89.7 Magic 98.3 Light It Up Radio CIHO FM 96.3 98.9 The Goat La Radio De Levis CILE MF 95.1 FM UMFM 101.5 FM CJTT 104.5 FM Khalsa FM Dimensions in Jazz CKBN 90.5 FM CKOC 1150 Classic Hits UP 93.1 XWave Radio 98.5 FM Montreal Artisan Radio 103.9 FM Sounds Of Portugal CJAM 91.5 FM LiVE 88.5 FM CJAI 92.1 FM Team 1040 95.7 Sun FM Onlyrockfm Capital FM 96.3 Hi-Tunes The Rig 96.7 The Lounge Sound Planète 99.5 ADJ Dance News 1130 Sun FM 98.5 NetMusique Eletronica CJSO 101.7 FM Guru Nanak Gurdwara Lake FM 92.7 89.5 The Drive Country 840 CKOM 650 AM Star FM 97.5 Kemptville Life 100.3 Radio Kaos A2Zen.fm BleuFM CIDI 99.1 FM Radio The Valley Wolf Rythme FM 105.7 Montreal CKLM The Goat 106.1 FM Hindi Desi Bollywood Evergreen Hits The Bounce 101.3 Horizon FM CHMA 106.9 FM PodRadio Beta HNE RockXradio 890 CJDC Mix 107.9 FM QMFM 103.5 CIGN FM The EAGLE 94.1 O 97.3 COUNTRY 88.9 CJBK 1290 247 the mix DAP FM Vanakkam FM 105.9 CITR 101.9 FM 580 CFRA News Talk Radio The Humming Bird The X 92.5 FM Northern Manitoba Fire and EMS",
  "dtp": "June 1, 2015",
  "dtxt": "100 - 500",
  "n": "lex.ottawamusic.biz",
  "new": "",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4,
  "rct": 1,
  "sz": "2.7M",
  "t": "Ottawa Music ONLINE",
  "verc": "2889",
  "id": "lex.ottawamusic.biz-2889"
 },
 {
  "_id": "5604457c703498dd2a526804",
  "cadd": "",
  "cat": "Music & Audio",
  "crat": "Everyone",
  "crt": "LEX Andra",
  "curl": "/store/apps/developer?id=LEX+Andra",
  "dct": 100,
  "desc": "Athens Music in HQ format. Download and enjoy the world of Music! This is a collection of Athens Music channels. Free Internet Radio Stations. Listen to all of the best Athens Radios!  - refresh list of streams - internet connexion starting with 24 Kbit/sec - instant Track Info - share button - most popular channels Receive a call and the radio is automatically off! Only the original broadcast with highest quality! Please use a fast internet connection for top app performance. If you find errors, please report and we will refresh the channels. We offer 24 hour customer support! 

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

[
 {
  "_id": "56044569703498dd2a52506d",
  "cadd": "",
  "cat": "Business",
  "crat": "Unrated",
  "crt": "Apps By Me",
  "curl": "/store/apps/developer?id=Apps+By+Me",
  "dct": 500,
  "desc": "Start Accepting Online Payments Instantly No paperwork, no approval process! You can register for an account and begin accepting payments on your website in just minutes! And you get unlimited credit card processing with no limits on how much you can make or process a day Instant Payment Notifications You are notified instantly via e-mail when someone sends funds to your account. We accept all online businesses. Sell Online We are a reliable payment processor and will not \"freeze\" or \"suspend\" your account for any reason other than fraud or spam! Check your email after sign up for Your Authorize.net information, and a link to how to videos to set up your account if you need more help. Or call or email us at any time. We are the best paypal alternative visit us now at  http://www.pompeypayments.com",
  "dtp": "September 15, 2014",
  "dtxt": "500 - 1,000",
  "n": "com.andromo.dev364482.app339937",
  "new": "",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://pompeypayments.com/policy.htm&sa=D&usg=AFQjCNGGkK14i3AIlTJl9V7xNy9_QHA4Dw",
  "rate": 3,
  "rct": 5,
  "sz": "1.8M",
  "t": "Accept Payments",
  "verc": "7733",
  "id": "com.andromo.dev364482.app339937-7733"
 },
 {
  "_id": "56044569703498dd2a525125",
  "cadd": "MBE 103, 1F Sunshine 60, 3-1-1, Higashi-Ikebukuro, Toshima-ku, Tokyo 170-6001, Japan",
  "cat": "Business",
  "crat": "Everyone",
  "crt": "Akikazu Yoshikawa",
  "curl": "/store/apps/developer?id=Akikazu+Yoshikawa",
  "dct": 1000000,
  "desc": "Celebrating 1 Million Downloads!!! AndrOpen Office is the world's first port of OpenOffice for Android. You can view, edit, insert and export office documents using full features of the OpenOffice. AndrOpen Office is office suite of 6 components: - Writer (a word processor) - Calc (spreadsheet / worksheet) - Impress (presentation graphics) - Draw (drawing) - Math (equation editor) - Base (database) * AndrOpen Office is forked project from the Apache OpenOffice project. AndrOpen Office is not affiliated with the Apache OpenOffice and LibreOffice project. Supported File Formats You can import and export following formats: - Microsoft Word (DOC / DOT / RTF) - Microsoft Excel (XLS / XLT) - Microsoft PowerPoint (PPT / POT) - OpenDocument (ODT / ODS / ODP / ODG / ODF) - OpenOffice.org1.0 / StarOffice6.0 (SXW / SXC / SXD / SXI / SXG / SXM) - Text (TXT / CSV) - Adobe Photoshop (PSD) - Scalable Vector Graphics (SVG) - Windows Metafile (EMF / WMF) - Tagged Image File Format (TIFF) - Data Interchange Format (DIF) - SYLK (SLK) - Portable Anymap Format (PBM / PGM / PPM) - OS/2 Metafile (MET) - Sun Raster Image (RAS) - Mac Pict (PCT) - X PixMap (XPM) - StarView Metafile (SVM) You can import following formats: - Microsoft Word 2007 (DOCX / DOTX / DOCM) - Microsoft Excel 2007 (XLSX / XLTX / XLSM) - Microsoft PowerPoint 2007 (PPTX / POTX / PPTM) - AutoCAD (DXF) - T602 Document (602) - Computer Graphics Metafile (CGM) - Truevision Targa (TGA) - X Bitmap (XBM) - Zsoft Paintbrush (PCX) - Kodak Photo CD (PCD) You can export following formats: - Portable Document Format (PDF) - HyperText Markup Language (HTML) - PlaceWare (PWP) - Macromedia Flash (SWF) - JPG / GIF / PNG / BMP Features - View / edit / insert / export docs - High fidelity - Formatting paragraphs - Support for embedded object - Export docs to PDF - Save docs to extensive file formats - Support for password - Internationalization - Localization - Support for macro - Support for Google Drive (Android 4.4+) / DropBox / Box / WebDAV - Support for spell checker, hyphenator, thesaurus - Support for printing (Android 4.4+) Motion Event Assigns Device's motion events (mouse, pen, finger, trackball) are assigned to mouse events of X Window System. - Single Tap = Click Left Button - Double Tap = Double Click Left Button And some gestures are assigned to application actions. - Swipe = Scroll - Pinch In / Out = Zoom In / Out - Long Tap = Click Right Button And you can general mouse operations by virtual mouse pad. Supported Languages Arabic / Czech / Danish / German / English (British) / English (US) / Spanish / Finnish / French / Hungarian / Italian / Japanese / Korean / Dutch / Polish / Portuguese (Brazilian) / Russian / Slovak / Slovenian / Swedish / Chinese (simplified) / Chinese (traditional) / Portuguese (European) / Greek / Indonesian / Turkish Known Issues https://sites.google.com/site/andropenoffice/bug-reports Links Twitter https://twitter.com/andropenoffice Bug reports Please report bugs below e-mail address; andropenoffice.bugreport@gmail.com About Apache OpenOffice \"Apache OpenOffice\" is a trademark of the Apache Software Foundation. ( http://openoffice.apache.org/ ) Special Thanks This product includes many open source codes (not GPL). Thanks to Open Source!!!",
  "dtp": "Septe

(answer)

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

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

[
 {
  "_id": "5604457c703498dd2a526fda",
  "cadd": "",
  "cat": "Entertainment",
  "crat": "Everyone",
  "crt": "RQ Droid",
  "curl": "/store/apps/developer?id=RQ+Droid",
  "dct": 10000000,
  "desc": "XRay Scan application is a prank fake xray scanner to trick your friends that you have awesome phone app that can X-ray their left hand. This app XRay Scanner app display fake image xray skeletal left hand. Control the movement by touching your phone screen, scroll your finger will scroll the xray skelatal screen, retouch will reverse the scroll movement. This is a fake xray scanner, not a real X-ray, it's a prank xray app with moving x-ray skeletal left hand image, this app is for entertainment only.",
  "dtp": "July 29, 2014",
  "dtxt": "10,000,000 - 50,000,000",
  "n": "xrayscan.regque",
  "new": "Updated to latest sponsor library code.",
  "os": "2.2 and up",
  "pri": "Free",
  "purl": "",
  "rate": 2.9,
  "rct": 88532,
  "sz": "290k",
  "t": "Xray Scan",
  "verc": "8997",
  "id": "xrayscan.regque-8997"
 }
]

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?

{"$and":[{"rct":{"$gte":1000000}},{"rate":{"$gt":4}}]}

[
 {
  "_id": "5604459c703498dd2a52988a",
  "cadd": "500 Howard St. Suite 300\nSan Francisco CA 94105",
  "cat": "Action",
  "crat": "Unrated",
  "crt": "Glu",
  "curl": "/store/apps/dev?id=8633921029894576093",
  "dct": 10000000,
  "desc": "High-end, immersive tablet gameplay! Lead the charge on D-Day as the tip of the spear in the largest Allied invasion of WW2!  Defeat the occupation forces and take back France; storm the beaches, clear the trenches and liberate towns as you battle through the countryside of Normandy. SEE AND FEEL THE ACTION! Experience the ultimate 3rd person shooter with stunning console quality visuals, precise controls, advanced physics, destructible environments and full voiceovers.  Jump into the heat of battle and push your device to the limit! HUGE SINGLE-PLAYER CAMPAIGN! Experience 5 separate campaigns with 145 separate missions based on the actual beach landings; Juno, Sword, Utah, Gold and Omaha.  Destroy powerful tanks and cannons to allow allied forces to advance.  Grab a stationary gun and unload against fortified positions.  Man the Ack-Ack anti-aircraft guns to take down bombers and their escorts before they can release their payloads. RUN THROUGH THE WARZONE! Battle your way into the heart of enemy territory! Run through the battlefield dodging mines and leaping barriers as you move to the next cover point to avoid enemy fire.  Emerge from destructible cover points to engage waves of enemies! COMMAND AN ARSENAL OF DEADLY WEAPONS! Take to the frontline with an array of classic weapons from World War 2.  Grab a historic rifle to take down enemies accurately or, if you prefer, a machine-gun to unleash a hail of bullets.  Call in Artillery strikes against entrenched enemy soldiers or shoulder a bazooka to reduce a tank to rubble.     Frontline Commando: D-Day is free to play, but you can choose to pay real money for some extra items. Use of this application is governed by Glu Mobile’s Terms of Use. Collection and use of personal data are subject to Glu Mobile’s Privacy Policy. Both policies are available at www.glu.com. Additional terms may also apply. FOLLOW US at Twitter @glumobile facebook.com/glumobile READ_CONTACTS – The game reads your contacts only to allow you to invite your friends to play. getLine1Number - This permission was accidentally included but is not used by this game. We will remove in an update in near future.",
  "dtp": "May 16, 2014",
  "dtxt": "10,000,000 - 50,000,000",
  "n": "com.glu.flcn_new",
  "new": "► Bug fixes and other improvements to game performance",
  "os": "2.1 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.glu.com/privacy&sa=D&usg=AFQjCNF7XANVJOJ3yOzV7ujS46miEuS0Xg",
  "rate": 4.5,
  "rct": 1048312,
  "sz": "335M",
  "t": "FRONTLINE COMMANDO: D-DAY",
  "verc": "6911",
  "id": "com.glu.flcn_new-6911"
 },
 {
  "_id": "56044593703498dd2a528f74",
  "cadd": "Gameloft S.E\n14 rue Auber,\n75009 Paris,\nFrance",
  "cat": "Role Playing",
  "crat": "Teen",
  "crt": "Gameloft",
  "curl": "/store/apps/dev?id=6258770168633898802",
  "dct": 10000000,
  "desc": "Venture forth into the most immersive, accomplished, and addictive chapter of the acclaimed action RPG saga! ***** REDISCOVER THE THRILL OF DUNGEON CRAWLER GAMES - Hack your way through an EPIC STORYLINE & a dark fantasy adventure - SLASH hundreds of enemies and massive bosses  - LOOT countless items ***** EXPERIENCE A TRUE RPG - Choose from 4 types of warriors with unique combat styles - UPGRADE your battle skills - CUSTOMIZE, craft and charm your gear  - Throughout the game, unveil the mysteries surrounding your warriors ***** GO FOR MULTIPLAYER ACTION - Fight along your friends in the CO-OP arenas  - Show off your battle skills in the action-packed PVP mode - Gather up and fight other warriors in TEAM DEATHMATCH games The Demons, a race thought to have been extinguished eons ago, have returned. You awaken from what seemed like a nightmare to find your kingdom, Valenthia, decimated. Unharmed from the battle, you are mysteriously gifted with tremendous new power and skills. You could be your people’s only remaining hope…  Embark on an epic adventure and get ready to fight your way through intense solo and multiplayer levels in this new free installment of the iconic dungeon crawler game.  This free fantasy game is best suited for fans of: hack 'n slash, action RPGs, dark fantasy games, multiplayer and free adventure games.  If you are one of them, get the game now for free! _____________________________________________ Visit our official site at  http://www.gameloft.com Follow us on Twitter at  http://glft.co/GameloftonTwitter  or like us on Facebook at  http://facebook.com/Gameloft  to get more info about all our free upcoming games. Check out our videos and game trailers on  http://www.youtube.com/Gameloft Discover our blog at  http://glft.co/Gameloft_Official_Blog  for the inside scoop on everything Gameloft. Privacy Policy :  http://www.gameloft.com/privacy-no

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?

{"$and":[{ "cat":{"$not" :{"$in": [ "Card", "Entertainment", "Comics", "Puzzle"] }}}, {"crat" : "Teen"} ]}

[
 {
  "_id": "56044569703498dd2a52509e",
  "cadd": "",
  "cat": "Music & Audio",
  "crat": "Teen",
  "crt": "RSQ APP",
  "curl": "/store/apps/developer?id=RSQ+APP",
  "dct": 1000,
  "desc": "Mali Radios aquí podrás escuchar las radios más populares radios de Mali El Catálogo de Emisoras es provisto oficialmente por su dueños a través de internet. Encuentra las siguientes estaciones: -Radio Dounia -Radio Dakan -Radio Jekafo -Radio Benkan -Radio Befo Internationale -Malijet Radio -Radio Badenya -ORTM LA CHAINE 2 -Radio Bamakan -Voix du Citoyen -Radio Wassoulou Internationale -Radio Studio Tabale Mali -Radio Kledu -Radio Madjoua -Radio Nieta -Radio Peace FM -Radio Peace 2 -Radio Paranormalium -Playlista -La voix du citoyen sur",
  "dtp": "June 1, 2015",
  "dtxt": "1,000 - 5,000",
  "n": "com.andromo.dev396765.app377067",
  "new": "-new radios",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 3.5,
  "rct": 20,
  "sz": "2.7M",
  "t": "Mali Radios",
  "verc": "7431",
  "id": "com.andromo.dev396765.app377067-7431"
 },
 {
  "_id": "56044569703498dd2a5250c0",
  "cadd": "",
  "cat": "Social",
  "crat": "Teen",
  "crt": "Starlight Apps",
  "curl": "/store/apps/developer?id=Starlight+Apps",
  "dct": 1000,
  "desc": "Online Verification. By using the PAN Verification facility, one can know/verify the Permanent Account Number (PAN). This facility is referred to as \"PAN.",
  "dtp": "July 19, 2015",
  "dtxt": "1,000 - 5,000",
  "n": "com.andromo.dev431972.app420683",
  "new": "",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.6,
  "rct": 28,
  "sz": "2.1M",
  "t": "Verify PAN",
  "verc": "4769",
  "id": "com.andromo.dev431972.app420683-4769"
 },
 {
  "_id": "56044569703498dd2a5250c1",
  "cadd": "",
  "cat": "Media & Video",
  "crat": "Teen",
  "crt": "Zero One Technologies",
  "curl": "/store/apps/dev?id=6930175597911982473",
  "dct": 50,
  "desc": "- Stream or download every episode of the Veteran Gamers Podcast. - Browse the website blog and Facebook page. - Stay up to date with all the Veteran Gamers videos from YouTube. - Harness the power of Duke's most popular sound effects in Duke's Sound Board. Even use them as notifications or ringtones! - Directly email the show to get all those important matters off your chest.",
  "dtp": "August 15, 2015",
  "dtxt": "50 - 100",
  "n": "com.andromo.dev428948.app391863",
  "new": "Bug fix.",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 5,
  "rct": 11,
  "sz": "4.7M",
  "t": "Veteran Gamers",
  "verc": "3367",
  "id": "com.andromo.dev428948.app391863-3367"
 },
 {
  "_id": "56044569703498dd2a525111",
  "cadd": "9450 SW Gemini Dr #60274\nBeaverton, OR 97008-7105",
  "cat": "Sports",
  "crat": "Teen",
  "crt": "Conjugo LLC",
  "curl": "/store/apps/developer?id=Conjugo+LLC",
  "dct": 10000,
  "desc": "Get the latest Atlanta Braves news, videos, photos, social media updates, podcasts, matchup tool, scores, team store and chat with Braves fans in this all in one unofficial FREE fan app!",
  "dtp": "May 23, 2015",
  "dtxt": "10,000 - 50,000",
  "n": "com.andromo.dev86290.app221279",
  "new": "- Bug fixes - Fan bars map - Other apps",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.conjugo.com/privacy.php&sa=D&usg=AFQjCNGT5MyF9MV19LHSVyd8JETMWq3yew",
  "rate": 4.1,
  "rct": 75,
  "sz": "4.3M",
  "t": "Atlanta Baseball",
  "verc": "1843",
  "id": "com.andromo.dev86290.app221279-1843"
 },
 {
  "_id": "56044571703498dd2a525242",
  "cadd": "神奈川県川崎市中原区中丸子１３−１０クラッシィタワー",
  "cat": "Social",
  "crat": "Teen",
  "crt": "Nakanishi,inc.",
  "curl": "/store/apps/developer?id=Nakanishi,inc.",
  "dct": 10000,
  "desc": "Merry'lは楽しく話せるトーク友達を探せる完全無料で遊べるSNSアプリです。 Merry'lで見つけた友達とトークを通じて楽しいコミュニケーションをはじめましょう。 共有タイムラインにトーク募集書き込みを行なうだけで、 あなたに興味をもった相手との出会いがあるかもしれません。 あなたの好みのプロフィールで検索が出来ます。 もし相手が気に入らない相手なら、相手とのトークリストを長押しすることでブロックできます。 寂しい時間や、ひまな時間をMerry'lで楽しく笑える時間に。 [機能] さがす -話したい相手をさがしましょう フォロー -気があうユーザーをフォローしましょう トーク -今までの会話履歴確認とトークが送信できます ブロック -不快なユーザーはブロックすることで安心してご利用できます あしあと -自分のプロフィールを閲覧した他のユーザーをチェックできます 以上の機能であなたのことを気になっている人、 あなたの気になる人とすぐにトークでやり取り出来るでしょう。 ※より便利になる機能をアプリ内課金で利用できますが基本機能はすべて無料で利用出来ます。 ※本アプリはタブレット、WALKMANには対応しておりませんので、ご利用されると不具合が起きる可能性があります。ご了承ください。 ※投稿やプロフィールは常に監視されており、利用規約に反するユーザーは数日間アカウント凍結となり使用することが出来ません。 ※アカウント凍結は通常3日間で解除されます。 ※本アプリは姉妹アプリ「Chatter」、「タダトモ」のユーザーともやりとりが可能です。",
  "dtp": "August 12, 2015",
  "dtxt": "10,000 - 50,000",
  "n": "com.laugh.merry",
  "new": "----------v1.2.7-9------------- ・不具合修正 ----------v1.2.6------------- ・フォロータイムライン機能改善 ・バグ修正 ----------v1.2.3------------- ・フォロータイムラインβ版公開 ----------v1.2.1------------- ・バグ修正 ------------------------------- iOS版とのパッケージ名統合 ウォークマン、タブレットで起こっていた登録処理不具合の修正。",
  "os": "4.0 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://central-west.co.jp/privacy_policy/index.html&sa=D&usg=AFQjCNH83EvcqItQM1QLoabRjbOclM10mA",
  "rate": 3.3,
  "rct": 159,
  "sz": "3.1M",
  "t": "完全無料のトーク友達が作れるアプリ Merry'l(メリル)",
  "verc": "8482

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?

{"$and": [{"$text":{"$search": "in-app purchase"}}, {"dct": {"$gte":10000000}}]}

[
 {
  "_id": "560445ac703498dd2a52ae9b",
  "cadd": "Viale della Repubblica, 299\n00047 - Marino (RM)\nItalia",
  "cat": "Communication",
  "crat": "Everyone",
  "crt": "Medieval Software",
  "curl": "/store/apps/developer?id=Medieval+Software",
  "dct": 10000000,
  "desc": "Use your smartphone to browse, explore and manage files of any Bluetooth ready device, using File Transfer Profile (FTP) and Object Push Profile (OPP): you can also receive files and send contacts! GUIDE>  http://help.medieval.it  (by Absolutely Android) FEATURES> * Custom security manager for incoming BT connections: only authorized devices can connect, if you accept. If you refuse, no access is granted on your servers: personal data files and privacy are safe against hacker, nerd, geek and guru (enanched Bluetooth server security is disabled by default) * 3rd party applications can open (or pick) files from sdcard using this package like attachment, music, pictures or any multimedia file (no external intents are supported for performance purpose) * Support for legacy 2.0 and AES (128, 192 and 256 bit) encryption (both pack and unpack) of Zip files (like WinZIP or WinRAR) - keep private document secure using a long pass to protect it * Enhanced all-in-one app with the fastest file browser ever seen (you can verify by yourself, test it now) * Professional, clean and fast UI where you can customize any aspect of the file viewer. Customizable user interface in order to best fit your needs (expert only) * Thumbnails for APK, audio, video, image (also inside archive files: Zip, GZip, TAR) - thumb picture (miniature) not stored on cell phone memory * It can connect to new and old cellphone: nokia, samsung, lg, sony (Android does not support infrared IR pan) * Search files also inside Zip, GZ, Tar (advanced searching inside archive can take double time to complete) * Improved contact send function in order to manipulate telephone numbers on generated VCARD (vcf) files * Cut, copy, move, paste, delete multiple items using the integrated explorer of this application * You can full unhide (or hide) hidden media (both smartphone and sd memory) * OBEX layer (obexftp and obexopp) entirely developed by Medieval Software * Compress, uncompress and extract Zip (encrypt with password), GZip, Tar * Cleaner program settings view using shortcut icons pane * Sharing: you can share a single file or an entire path * Powerful bookmark feature with precise sorting * Contact send screen supports contacts groups * Test and check archive integrity (deflate) * Desktop folders shortcuts * Calculate MD5 and CRC32 * Power saving management * Streaming service * No root required * Multi language * Multiselect * Home folder * File sort * Open as Freeware with AD (free software) - You can now remove advertising from this application by purchasing \"Medieval Licensing System\" on the Android Market! NOTE - SDPD (uuid port route) may not work on Android 1.5 and 1.6 so friend services could not reach you! --- FAQ> Why \"Bluetooth File Transfer\" requires the contact read permissions? A. In order to send your contacts over Bluetooth, if you wish, for example to your car-kit or to another smartphone. Open main menu, select Send contacts item, put a check beside the contacts you would like to send and finally press Send button.",
  "dtp": "November 16, 2014",
  "dtxt": "10,000,000 - 50,000,000",
  "n": "it.medieval.blueftp",
  "new": "Version 5.55: * Fix for Android 5.0 (Lollipop). Version 5.50: * Added the Phone Book Access Profile (OBEX PBAP) client in order to download contacts via Bluetooth. Version 5.45: * Removed the old live folder provider for home-screen; * Fixed thumbnail engine for huge directories; * Minor bug fixes. Version 5.40: * Stable version with additional bug fixes and Bluetooth improvements (for Android 4.x only). Version 5.35: * A lot of bug fixes.",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "",
  "rate": 4.2,
  "rct": 238199,
  "sz": "Varies with device",
  "t": "Bluetooth File Transfer",
  "verc": "4675",
  "id": "it.medieval.blueftp-4675"
 },
 {
  "_id": "56044572703498dd2a525b56",
  "cadd": "Russia, Rostov-on-Don",
  "cat": "Action",
  "crat": "Teen",
  "crt": "RiliSoft",
  "curl": "/store/apps/developer?id=RiliSoft",
  "dct": 10000000,
  "desc": "Try Pixel Gun 3D in MULTIPLAYER MODE with Cooperative, Deathmatch & Deadly Games!  Also it is a cool modern block world shooter with singleplayer campaign and survival arena.   Now you have a perfect chance to battle with your friends, classmates and colleagues or anyone else around the world! You can create and customize your character using a special skins maker and then show off on the battlefield!  It is an awesome pocket FPS shooter for all kinds of players!  *** MULTIPLAYER MODES***   Deathmatch mode benefits:   • WORLDWIDE and local.   • unique maps of various shapes and sizes.   • Varied weaponry, ranging from Magic Bow, Combat M16 Rifle, Golden Desert Eagle and Lightsaber to the simp

There are 147 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 "")

{"$and": [{"dct": {"$gt":1000000}}, {"rate": {"$gt": 4.5}}]}

[
 {
  "_id": "5604457c703498dd2a526263",
  "cadd": "4880 Santa Rosa Rd\nCamarillo, CA 93012",
  "cat": "Books & Reference",
  "crat": "Everyone",
  "crt": "Salem Web Network",
  "curl": "/store/apps/developer?id=Salem+Web+Network",
  "dct": 5000000,
  "desc": "DailyBible is the most liked Bible app on Android.  Daily Bible Verse  Daily Bible Reading Plan Easy & Fast Search any Bible verse of topic. Daily Bible devotionals. Bible Index Supports many versions( NIV, KJV, ESV, etc.) Save or Share Bible verse or plan or devotions easily  on Facebook, Twitter, etc Home widget for daily Bible verse ------------------------------------ Daily Bible Verse :     - Start your day with a daily Bible verse. You will get automatic daily notification. You can read or just listen. Choose Bible verse in different versions like KJV, NIV, ESV, etc Daily Bible Reading Plan :    - Choose from a wide range of Bible reading plans and read Holy Bible. DailyBible can play back the reading plan. You can read or just listen. Easy & Fast Search any Bible verse or topic:   - Easily search any verse of any topic. Search from a wide range of Bible Versions like KJV, ESV, NIV and lots more. Just speak to search. Daily Bible devotionals.   - Listen to a wide range of Biblical Christian Devotions. Choose from a huge list of devotional podcasts. Read or listen from devotions.    - Save a Bibe devotional podcast and listen to it offline - Bible Index    Read or Listen to any chapter from any book in Holy Bible easily. Supports multiple Bible versions like KJV, NIV, ESV, etc.    - Save or Share Bible verse or plan or devotions easily  on Facebook, Twitter, email, text etc. ----------------------- Permissions requested by DailyBible, how it is used and why it is needed ------------------------- 1) android.permission.INTERNET -  Needed to refresh daily Bible verse, daily Bible plans, devotions and searches. 2) android.permission.READ_PHONE_STATE -  To automatically stop the audio (devotions, daily verse, etc) playing if any, when an incoming call comes. 3) android.permission.WRITE_EXTERNAL_STORAGE -  To Save verse, plan and podcasts to external storage, when you choose to save it. 4) android.permission.WAKE_LOCK -  So that the audio can be played in background without stopping when phone goes to sleep. 5) android.permission.RECEIVE_BOOT_COMPLETED -  For refreshing daily verse after phone is rebooted. ---------------------------------------",
  "dtp": "September 11, 2015",
  "dtxt": "5,000,000 - 10,000,000",
  "n": "joansoft.dailybible",
  "new": "Updated DFS ads Bug fixing",
  "os": "2.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.7,
  "rct": 140431,
  "sz": "3.9M",
  "t": "Daily Bible",
  "verc": "9646",
  "id": "joansoft.dailybible-9646"
 },
 {
  "_id": "56044594703498dd2a52901a",
  "cadd": "999 N Sepulveda Blvd, Ste 150, El Segundo, CA, United States",
  "cat": "Arcade",
  "crat": "Teen",
  "crt": "GAMEVIL Inc.",
  "curl": "/store/apps/dev?id=8370361226290054499",
  "dct": 5000000,
  "desc": "Cartoon Wars: Gunner+ Cartoon Wars: Gunner+ is a side scrolling, action-packed game incorporating elements from RPG and adventure genre. ─────────────────────  SCENARIO In the midst of war in the Cartoon World, a king devised a deadly plan to slay the much-praised Captain J, as his presence was threatening the king's position. Chased with ferocious troops on his back, Captain J fled into the mountains with a serious injury. The arrogant king, who once hailed his troops for the victory, faces an iminent danger yet again with his foe, Captain J. ───────────────────── FEATURES MULTIPLE CHARACTERS FOR UNLIMITED ACTION Fight against 30 different type of enemies- each with unique skill sets and attacking range WEAPON MASTERY Choose from 11 unique array of weapons and master them as you fight against evil troops VENGEANCE PREVAIL Gain valuable skills by upgrading weapons and go head-to-head with the evil army to bring back the glory UPGRADABLE SKILLS Become the ultimate hero by upgrading and activating the weapons to either active or passive skills BOOST EARNINGS Vastly increase Gold and MP earnings by wisely choosing from different type of weapons ─────────────────────  NEWS & EVENTS  Website  http://www.gamevil.com   Facebook  http://facebook.com/gamevil   Twitter  http://twitter.com/gamevil   YouTube  http://youtube.com/gamevil",
  "dtp": "August 19, 2014",
  "dtxt": "5,000,000 - 10,000,000",
  "n": "com.gamevil.cartoonwars.gunner.global",
  "new": "- Minor bugs fixed Contact GAMEVIL Inc. @ Tips & Tricks: http://iphone.gamevil.com Facebook: http://facebook.com/gamevil Twitter: http://twitter.com/gamevil YouTube: http://youtube.com/gamevil Email: contact@gamevilusa.com",
  "os": "2.2 and up",
  "pri": "$0.99",
  "purl": "https://www.google.com/url?q=http://us.gamevil.com/news.php?m%3Dpolicy&sa=D&usg=AFQjCNG9nUZVpGZ16sqZlhU6_LzEAHJaXg",
  "rate": 4.6,
  "rct": 197688,
  "sz": "18M",
  "t": "Cartoon Wars: Gunner+",
  "verc": "1519",
  "id": "com.gamevil

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?

{"$and":[{"dct":{"$gte":1000000}},{"purl": ""}]}

[
 {
  "_id": "56044569703498dd2a525175",
  "cadd": "8333 Paseo Vista Dr.\nLas Vegas, NV 89128",
  "cat": "Puzzle",
  "crat": "Everyone",
  "crt": "aniFree",
  "curl": "/store/apps/developer?id=aniFree",
  "dct": 1000000,
  "desc": "Balling is a 3D puzzle, logic, and balance game. Control the ball to travel through the path and reach the goal portal within limited time.  Pick up hourglasses to get more time. There are 3 kinds of balls: wooden, stone, and paper. Use the transformers to change to the right ball. This version has 12 levels. More levels coming soon. Suggestions and comments are welcome. Levels walk through:  https://www.youtube.com/playlist?list=PLCRbG3aMRHxcaKbS7YMk4AWuw36b_TiSQ Tags: ballance, balance, ball, balling, 3D",
  "dtp": "February 10, 2015",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.anifree.balling",
  "new": "",
  "os": "2.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 3.8,
  "rct": 22853,
  "sz": "26M",
  "t": "Balling",
  "verc": "4675",
  "id": "com.anifree.balling-4675"
 },
 {
  "_id": "56044569703498dd2a5251c7",
  "cadd": "Kozlova str. 15-9, Minsk, Belarus",
  "cat": "Card",
  "crat": "Unrated",
  "crt": "Alexei Anoshenko",
  "curl": "/store/apps/developer?id=Alexei+Anoshenko",
  "dct": 1000000,
  "desc": "\"Favorite Solitaires\" is a collection of the 12 most popular solitaire games: Algerian Patience, Calculation, Canfield, Freecell, Golf, 2 variant of Klondike, Pyramid, Scorpion, Spider, Trefoil, Tri-Peaks.  For each game there is a description of the rules and a demonstration.",
  "dtp": "July 18, 2014",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.anoshenko.android.fav_solitaires",
  "new": "v.2.3.0 Added ability to remove ads Updated Polish, Swedish and Norwegian translation Bug fixing v.2.2.0 Improved autoplay and \"Collect all\" function Added German, French, Spanish, Italian, Japanese, Korean, Traditional Chinese and Simplified Chinese interface",
  "os": "2.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.3,
  "rct": 33469,
  "sz": "4.1M",
  "t": "Favorite Solitaires",
  "verc": "6567",
  "id": "com.anoshenko.android.fav_solitaires-6567"
 },
 {
  "_id": "56044571703498dd2a525228",
  "cadd": "Vedant Lath\nShree Complex\nRourkela - 769012\nOdisha",
  "cat": "Travel & Local",
  "crat": "Everyone",
  "crt": "Vedant Lath",
  "curl": "/store/apps/developer?id=Vedant+Lath",
  "dct": 1000000,
  "desc": "The one-stop application for Indian Railways train travellers. It is very fast and smooth and has many features like PNR status, train schedule, train running status, trains between stations, seat availability, etc. It has the following features: - Check PNR status of your Indian Railways train ticket - Check PNR status of all printable tickets from your IRCTC account - Train schedule from train name or train number (including train name search and automatic save of all train schedules) - Train map - Trains between stations (with an option to display seat availability of all matching trains in the same page) - Seat availability - Running status of a train - Arrivals and departures at a station - Fare enquiry - Display and save your IRCTC e-ticket/electronic reservation slip (ERS). This can also be shown to the TTE as a valid ticket with any of the recognised ID cards. Long press on a PNR and tap on \"Get e-ticket/ERS\" to use this option. - Train status map You can also enter your IRCTC username and password and it will get the ticket status of all printable tickets from your IRCTC account. All communication with your username and password is fully encrypted with SSL, RSA and/or AES encryption methods. Additional features: - saves PNR status of all tickets automatically - save one pair of IRCTC username and password to avoid entering it repeatedly (this is saved on your phone in the app's data folder) - saves IRCTC e-ticket automatically - displays train arrival and departure timings for each ticket - view status of several tickets at once - saves train schedule automatically so it can be viewed even if network is not available This application is for users of the Indian Railways train network only. This does not support railways of other countries. Disclaimer: This app is not affiliated with IRCTC or Indian Railways. Although we try our best to ensure that nothing undesirable happens with your account, we do not guarantee it and we are not liable for any action our app makes.",
  "dtp": "June 23, 2015",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.lathconsultants.PNR_status",
  "new": "*** Save e-ticket and other options can be used by tapping and holding the PNR number on the screen *** 0.12.49 - fix running status 0.12.47 - fix PNR status 0.12.42 - fix PNR status - fix running status 0.12.5 - show distance and ETA in running status - add option to copy PNR and to share PNR status - UI improvements - bug fixes 0.12.1 - fix compatibility with Android 1.6 - do not show ads if pro version is installed 0.12.0 - Save train schedule automatically",
  "os": "1.6

There are 913 apps.

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

Hint: You can use the $regex operator

{"dtp": {"$regex": "^September .*2015"}}

[
 {
  "_id": "56044572703498dd2a5254d7",
  "cadd": "",
  "cat": "Shopping",
  "crat": "Everyone",
  "crt": "Listia",
  "curl": "/store/apps/developer?id=Listia",
  "dct": 1000000,
  "desc": "Check out millions of FREE items other people are giving away nearby! Over 100 Million items have been traded for free on Listia! Listia is a mobile garage sale and yard sale marketplace like craigslist where you sell things you don't need and get stuff you want in return, for FREE. Earn credits by selling stuff for others to reuse, and use those credits to get stuff you really want, like Jewelry, Electronics, Clothing, Gadgets, Books, Toys, Gift Cards, Games and Coins. The more you give and sell, the more free things you can buy without spending money. How It Works: 1) Declutter - Sell all the things you don't use - from DVDs to Cell Phones, for free, like a mobile craigslist, yard sale or garage sale! 2) Earn Credits - Rack up credits when others buy your listings. 3) Reward Yourself - Discover and get stuff you'll love from other members or the Listia Rewards Store! The mobile app makes listing auctions to sell a snap. Simply take a photo with your device, add some details, and post it to Listia instantly. The Listia app will show you what nearby users are trading, selling & giving away, let you buy and bid on things you want, and notify you when you're outbid or an item you're watching is ending. Next time you feel like listing things in the free section of craigslist or sell at a local garage or yard sale, give Listia a try and see all the cool things you can get!",
  "dtp": "September 1, 2015",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.listia.Listia",
  "new": "* Improvements to credit buying * Bug fixes Please use in-app support if you encounter any problems. Give us a five-star review if you like the app. Enjoy! Listia updates our app regularly to give you the latest features. You can keep your app updated automatically by enabling the \"Auto-update apps\" setting in Google Play.",
  "os": "4.0 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.listia.com/privacy&sa=D&usg=AFQjCNHQhm47L147Pf6QR0Jj9mVZocrSUw",
  "rate": 4.2,
  "rct": 25269,
  "sz": "6.2M",
  "t": "Listia - Get Free Stuff & Sell",
  "verc": "8865",
  "id": "com.listia.Listia-8865"
 },
 {
  "_id": "56044572703498dd2a5255e5",
  "cadd": "",
  "cat": "Tools",
  "crat": "Everyone",
  "crt": "Kc Ho",
  "curl": "/store/apps/developer?id=Kc+Ho",
  "dct": 10000,
  "desc": "Macau EasyGo, a fast way to inquire Macau bus routes and stops info OFFLINE! Further OFFLINE functions: - Point-to-point Route Search, - GPS Track Recording. ** Still considering? Download it now! (NOTE: Macau EasyGo App \"WILL NOT\" upload your tracks recorded by \"Track Recording\" function automatically.) The permission we need: [ precise location ] ..All the function using GPS location. [ modify or delete... ] ..Saving tracks. [ full network... ] ..Checking updates. [ draw over... ] ..Next stop announcement function. [ control vibration ] ..Track recording. [ test access... ] ..Saving tracks.",
  "dtp": "September 1, 2015",
  "dtxt": "10,000 - 50,000",
  "n": "com.locmacau",
  "new": "V4.2.3 - + Update routes",
  "os": "2.2 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.5,
  "rct": 153,
  "sz": "6.0M",
  "t": "Macau Bus Guide & Offline Map",
  "verc": "3885",
  "id": "com.locmacau-3885"
 },
 {
  "_id": "56044572703498dd2a525ae6",
  "cadd": "100 Union Square Drive\nNew Hope, PA 18938",
  "cat": "Social",
  "crat": "Teen",
  "crt": "MeetMe.com",
  "curl": "/store/apps/developer?id=MeetMe.com",
  "dct": 10000000,
  "desc": "MeetMe helps you find new people nearby who share your interests and want to chat now! It’s fun, friendly, and free! Join 100+ MILLION PEOPLE chatting and making new friends. It’s for all ages, all nationalities, all backgrounds — EVERYONE! So what are you waiting for? Download the best app for finding new friends to chat with! -------- What Our Members Say: \"I've met people I'd never have met otherwise. And it's easy to chat with people. It just makes life a little better in my opinion.\" \"[It's] probably one of the greatest apps... greater variety of people... everyone is at one place at one time... meeting new people.\" \"MeetMe has given me the opportunity to talk to really terrific people.\" *** #1 Social App for Meeting New People in the US ***",
  "dtp": "September 1, 2015",
  "dtxt": "10,000,000 - 50,000,000",
  "n": "com.myyearbook.m",
  "new": "- Chat should be much faster, AND you can see when your messages are read! :)",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.meetme.com/terms.php%23privacy&sa=D&usg=AFQjCNGDSEw4EKE98izigm0hyDjSk0UXVQ",
  "rate": 4.2,
  "rct": 671555,
  "sz": "Varies with device",
  "t": "MeetMe: Chat & Meet New People",
  "verc": "7237",
  "id": "com.myyearbook.m-7237"
 },
 {
  "_id": "56044572703498dd2a5261b9",
  "cadd": "Geola 20 St., Side A,

There are 3202 apps