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

There are 40 apps.

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

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

[
 {
  "_id": "56044571703498dd2a52533c",
  "cadd": "",
  "cat": "Tools",
  "crat": "Everyone",
  "crt": "SHAREit Technologies Co.Ltd",
  "curl": "/store/apps/developer?id=SHAREit+Technologies+Co.Ltd",
  "dct": 50000000,
  "desc": "SHAREit, the world's fastest cross-platform file transfer tool for near-field communication. - Share all kinds of files whenever and wherever. - 200 times Bluetooth speed! - No USB! No data usage! No internet needed! - Supports Android, iOS (iPhone/iPad), Windows Phone, Windows XP/Vista/7/8/10, and Mac OS. - The choice of OVER 300 million users from 200 countries. - Top 1 downloaded App on Google Play in 15 countries and districts. 【Main features】 ► No network restriction Share files whenever & wherever! ► Fastest in the world 200 times faster than Bluetooth, the highest speed goes up to 20M/s. ► Cross-platform transferring Cross-platform sharing for phones & computers & tablets, Android & iOS & Windows Phone & Windows XP/7/8. ► Transfer whatever you have Photos, videos, music, installed apps and any other files. ► Simple and Easy Friends can transfer files to each other by entering Portal. So easy to share! ► Connect to PC Transfer files between phone and PC View your photos and play music on computers. Control PPT directly with your phone, making your presentation easier! ► CLONEit Replicate contacts, SMS messages, MMS messages, music, videos, apps and other data from your old phone to the new one in just one click. 【LIKE US and STAY CONNECTED】 ►Facebook   https://facebook.com/bestSHAREit ►Twitter   https://twitter.com/bestSHAREit ►VK   https://vk.com/bestSHAREit ►Instagram   https://instagram.com/bestSHAREit",
  "dtp": "September 22, 2015",
  "dtxt": "50,000,000 - 100,000,000",
  "n": "com.lenovo.anyshare.gps",
  "new": "1. Regained and optimized LAN transmission mode 2. Optimized the loading mechanism of the contents selection interface 3. Supported horizontal screen display for tablet 4. Improved the layout of some languages 5. Fixed a few bugs",
  "os": "2.2 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.4,
  "rct": 665894,
  "sz": "5.6M",
  "t": "SHAREit - Connect & Transfer",
  "verc": "6043",
  "id": "com.lenovo.anyshare.gps-6043"
 },
 {
  "_id": "56044571703498dd2a525341",
  "cadd": "",
  "cat": "Tools",
  "crat": "Everyone",
  "crt": "Leomaster",
  "curl": "/store/apps/developer?id=Leomaster",
  "dct": 50000000,
  "desc": "★ ★ ★ ★ ★Android store's TOP1 privacy safeguard★ ★ ★ ★ ★  Lock your privacy，Free your hand Why do I need this App?  The Most Trusted and Popular Privacy Protector for Android, keeping your phone safe from annoying snoopers and prying eyes. With LEO Privacy Guard, you can heave a sigh of relief and not worry about: Girlfriend/boyfriend is trying to go through all your SMS and call log, when you’re in the shower. Parents/kids are curious about your gallery and FB status. Colleagues accidentally see private images or videos when you let them use your phone. What does LEO Privacy Guard do? AppLock - Just a click to lock all apps. - Simple switch to change multiple modes. - Various ways to cover your apps, Mask on apps, Guard on phone. Privacy Protection - Privacy alerts keep you informed of phone safety. - Keep snoopers away from private pics, videos, SMS and call log. APP Management - Uninstall unwanted apps and back up the important ones. - Keep your data plan and battery usage under control easily. Stunning New Design - New design for user interface, simple, handy and intuitive. - Stylish themes to decorate your lock screen. shortcuts - Swipe to all APP with shortcuts - Everything within reach. For more info Website:  http://www.leomaster.com/ Facebook:  https://www.facebook.com/pages/LEO-Privacy-Guard/1709302419294051 Google+:  https://plus.google.com/u/0/109812241250582068738/posts",
  "dtp": "September 23, 2015",
  "dtxt": "50,000,000 - 100,000,000",
  "n": "com.leo.appmaster",
  "new": "1.Added Message Center,From here, you can easily catch up our interesting events, new features of Privacy Guard, and useful tips of our app and your phone. 2.Optimize upgrade function, update process will be much more smoother. 3.More guidance of advanced protective functions, which will better guard your privacy 4.Optimize App Lock & App Cover, quicker, smarter and more smoother 5.Optimize memory usage, improve operation performance, protect all your secrets with ease and grace.",
  "os": "4.0 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://leomaster.com/policy&sa=D&usg=AFQjCNGlYH6-c6eU43Q1lUjrgHKBkgV90A",
  "rate": 4.3,
  "rct": 908529,
  "sz": "4.9M",
  "t": "LEO Privacy Guard - AppLock",
  "verc": "8604",
  "id": "com.leo.appmaster-8604"
 },
 {
  "_id": "56044572703498dd2a52566e",
  "cadd": "",
  "cat": "Social",
  "crat": "Teen",
  "crt": "Zello Inc",
  "curl": "/store/apps/developer?id=Zello+Inc",
  "dct": 50000000,
  "desc": "Turn your phone or tablet into a walkie talkie with this lightning fast free PTT (Push To Talk) radio ap

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

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

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

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

[
 {
  "_id": "560445b0703498dd2a52b51b",
  "cadd": "Số 10 Trần Phú Str. Hà Đông Dist. Hà Nội, Việt Nam",
  "cat": "Entertainment",
  "crat": "Everyone",
  "crt": "Spirit Studio",
  "curl": "/store/apps/developer?id=Spirit+Studio",
  "dct": 10000,
  "desc": "5S Online - Một format sitcom mới nơi bạn tìm thấy tất cả các định nghĩa của tuổi 9X nay đã có mặt trên Android với ứng dụng  - Ứng dụng cập nhật nhanh nhất tập phim mới của bộ phim từ kênh youtube 5sonlinevietnam:  https://www.youtube.com/channel/UCL2BnoeVmDODuNEPuxobpug - Nội dung đồng bộ trực tiếp với fanpage 5S Online:  https://www.facebook.com/5sOnline - Khoảnh khắc 5S là các clip ngắn 7-15s ghi lại những khoảnh khắc vui nhộn, hài hước; những câu nói, câu chém gió bất hủ,...trong các tập phim.   - Full trọn bộ tất cả các tập phim với chất lượng HD Các tính năng nổi bật khác: + Tự động cập nhật và thông báo tập phim mới, News Feed mới từ Fanpage.  + Xem và bình luận Facebook.  + Like/Share lên các mạng xã hội Facebook, Twitter,...  + Copy và chia sẻ những đoạn văn, những câu nói hay mà bạn thích trên ứng dụng 1 cách dể dàng.  + Đánh dấu các bài viết, hình ảnh, video hay để xem lại.  + Tạo Widget ngay màn hình chính tiện cho việc theo dõi, nắm bắt thông tin.  + Thay đổi giao diện theo ý thích. Chỉ cập nhật tin tức khi bạn sử dụng kết nối Wifi, tiết kiệm chi phí 3G.  + Ẩn/Hiện các tin đã đọc. Có thể cài đặt tự động dọn dẹp tin đã đọc, chưa đọc. Quy tụ một dàn hot boy, hot girl nổi tiếng đã thổi một làn gió mới trong dòng phim Sitcom chứ không rơi vào quên lãng như những bộ phim trước. Nội dung chính của phim xoay quanh nhóm bạn trẻ làm việc trong một văn phòng sáng tác truyện tranh bao gồm Quyết (Mạnh Quân), Kiều Linh (Vân Navy), Trung (Anh Vũ), Nana (Chi Pu), Tường Vi (Quỳnh Anh Shyn) và Phan (Bê Trần). Bằng đam mê, sở trường của bản thân, nhóm bạn từng bước xây dựng nên bộ truyện tranh dành cho giới trẻ và ghi dấu ấn cá nhân lên những nhân vật mình đảm nhiệm. Tiêu chí của nhóm hướng đến 5 chữ S: Sáng tạo, Sành điệu, Say mê, Sốc và Sinh lợi. 5 thành viên của nhóm – 5 tính cách trái ngược, mâu thuẫn và bổ sung lẫn cho nhau. Còn Online tượng trưng cho mạng Internet, khi đây là yếu tố ảnh hưởng nhiều nhất đến giới trẻ bây giờ. Bộ phim là minh chứng cho thấy giới trẻ ngày nay không hề thờ ơ trước những thông tin thời sự nóng hổi, họ vẫn có tiếng nói riêng của mình và muốn được thể hiện chính kiến đó. Bằng lối diễn xuất tự nhiên, hài hước và gần gũi, dàn cast của 5S Online hy vọng sẽ truyền tải được thông điệp của bộ phim tới người xem qua mỗi tập phim. Ngoài dàn diễn viên trẻ đẹp, tài năng đang được khán giả trẻ hâm mộ, 5S Online còn được xây dựng bởi ê kip làm phim chuyên nghiệp dày dặn kinh nghiệm như biên tập Phi Tiến Sơn, đạo diễn Nguyễn Hữu Trọng, nhà quay phim từng đoạt giải LHP Cannes Lý Thái Dũng. Sự trở lại của các hotboy, hotgirl một thời Bộ phim có thể nói là sitcom quy tụ dàn diễn viên trẻ đẹp, tài năng là các hotboy, hotgirl lớn nhất từ trước tới nay, đặc biệt là Chi Pu – hotgirl nổi đình đám nhất năm 2013. Điều thú vị hơn, 3 trong số 5 diễn viên chính từng cùng tham gia một sitcom khác đình đám không kém cách đây vài năm là Nhật Ký Vàng Anh. So với những sitcom khác dành cho teen như Những phóng viên vui nhộn, Cửa sổ thủy tinh, Bộ tứ 10A8, … 5S Online có lợi thế vượt trội hơn hẳn. Bộ phim đánh dấu sự trở lại của Mạnh Quân, Vân Navy và Anh Vũ sau một thời gian tạm xa rời với khán giả teen vì những dự án, công việc riêng. Khán giả của họ lần này ở độ tuổi 9x sẽ có sự khác biệt nhỏ so với thời Nhật Ký Vàng Anh. Với Bê Trần và Chi Pu, 5S Online cũng có ý nghĩa lớn bởi đây là sitcom đầu tiên họ tham gia, đặc biệt với Bê Trần lần đầu thử sức với diễn xuất dài hơi. Bộ phim hứa hẹn sẽ tạo nên hiệu ứng tích cực tới cuộc sống của giới trẻ dựa nội dung hấp dẫn, gần gũi và bám sát thực tế.",
  "dtp": "May 13, 2015",
  "dtxt": "10,000 - 50,000",
  "n": "com.app.Sonline",
  "new": "Cập nhật một sô tính năng mới.",
  "os": "4.0 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://wahay.tv&sa=D&usg=AFQjCNHtqxSbmA7KxsZ43FcxC8ZELpR0bg",
  "rate": 4.4,
  "rct": 411,
  "sz": "5.7M",
  "t": "5S Online: The Movies",
  "verc": "2651",
  "id": "com.app.Sonline-2651"
 },
 {
  "_id": "56044572703498dd2a525b3a",
  "cadd": "Unknown",
  "cat": "Books & Reference",
  "crat": "Everyone",
  "crt": "ya-mahdi.net",
  "curl": "/store/apps/developer?id=ya-mahdi.net",
  "dct": 50000,
  "desc": "\"Divine Pearls\" is a Shia Islamic application. It contains Takeebat, Ziyaraat, Quranic Surahs, Aamaal and Duas. Features : •  Big and Clear Indian Style Arabic script •  No Need to Zoom in or Zoom Out •  Installs in SD Card •  Includes audio, translation & transliteration of almost everything •  Can also be installed on Tab •  Fully supports Small Screen devices •  Share any content including Arabic   •  Attractive UI Your feedback and suggestions will always help us improve. Contents : Surahs : Ayat al-Kursi, Surah A'ala, Surah Ahzab, Surah Dahr, Surah Falaq, Sura

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

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

Hint: Use the $in operator.

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

[
 {
  "_id": "56044568703498dd2a5242ba",
  "cadd": "",
  "cat": "Business",
  "crat": "Unrated",
  "crt": "WadeFx 3-D",
  "curl": "/store/apps/developer?id=WadeFx+3-D",
  "dct": 100,
  "desc": "Seismic AR Is an Augmented Reality Demo for corporations and businesses in the oil and gas industry. It shows a simple but powerful use of Augmented Reality for the oil and gas industry worldwide. To download the marker which allows you to see the model that is associated with augmented reality application please go to  http://wadefx3d.com/augmented-reality . The rising technology of Augmented Reality has mostly been used on mobile platforms in the games section of your app store, at WadeFx 3-D we are taking this technology to a more functional and professional level.  Augmented Reality is the technology that fuses the digital world to the real world it allows you to take nearly any object and surface and superimpose interactive 3-D content onto the target using the viewfinder of your smartphone or tablet. For the exploration section Augmented Reality Harnesses the combined data of surveys you already acquire (seismic, gravitational, magnetic, electrical and electromagnetic, Topography) we can create a full three dimensional cohesive presentation of the past, current, and future process of your projects. These presentations can be created and focused toward data room presentations, marketing, investor relations, training and more; You can even carry around an augmentation on the back of your business card. For the services section of the industry A/R can deeply explain how your new technology works from inside out allowing you peel away layers show functionality in a way like none before.",
  "dtp": "May 23, 2014",
  "dtxt": "100 - 500",
  "n": "com.WadeFx.Sesimic",
  "new": "Testing for the new Samsung S5",
  "os": "2.2 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.7,
  "rct": 3,
  "sz": "29M",
  "t": "Seismic AR",
  "verc": "1128",
  "id": "com.WadeFx.Sesimic-1128"
 },
 {
  "_id": "56044568703498dd2a524318",
  "cadd": "",
  "cat": "Business",
  "crat": "Unrated",
  "crt": "Horizon Distributors Inc",
  "curl": "/store/apps/developer?id=Horizon+Distributors+Inc",
  "dct": 500,
  "desc": "Green Industry Pro – your life just got a lot easier!  Designed to assist landscape and irrigation professionals in the field, Horizon's Landscape Irrigation Pro helps you find the solutions you need to get the job done. Identify troublesome weeds, insects, and diseases, access calculators you use every day, locate your closest Horizon store, and much more! Access Horizon’s Landscape Maintenance Guide This handy reference guide is now at your fingertips! You'll find time-tested tips & best practices on every major aspect of lawn care maintenance, including mowing, fertilizing, watering, weed control, and equipment maintenance. All targeted for your region and soil. Easy-to-Use Calculators ·Irrigation – ROI Calculator for Smart Water Conversion, Sprinkler & Drip Run Time, Sprinkler & Drip Precipitation Rates ·Equipment – Mow Rate per Hour ·Landscape – Fertilizer & Mulch Application, Tank Mix Calculator ·Outdoor Living – Voltage Drop, Sand Calculator for Paver Installation ·Conversions - Length, Area, Volume, Temperature, and Weight Find Your Closest Store Horizon’s app uses your current location to immediately locate the closest Horizon store. Use the quick dial feature to call ahead and have your order waiting at the counter. Looking for a Horizon Equipment Service Center? You’ll find that in the app too. Get Trained by Industry Experts Wondering when to fertilize this spring? Need a quick review on wiring an outdoor lighting system? Get expert answers to common questions in our Video FAQ section. You can also watch previously recorded Business Builder Webinars and learn how to grow your business by tapping into profitable niche markets. Other Valuable Resources -Horizon’s Catalog -MSDS Sheets -Industry links -Water rebate programs by state -Industry news & seasonal tips from our Blog",
  "dtp": "August 14, 2014",
  "dtxt": "500 - 1,000",
  "n": "com.a1.forsliding",
  "new": "",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 3.7,
  "rct": 6,
  "sz": "28M",
  "t": "Landscape Irrigation Pro",
  "verc": "1221",
  "id": "com.a1.forsliding-1221"
 },
 {
  "_id": "56044568703498dd2a52433a",
  "cadd": "",
  "cat": "Business",
  "crat": "Unrated",
  "crt": "Online Marketing",
  "curl": "/store/apps/developer?id=Online+Marketing",
  "dct": 100,
  "desc": "How to Create Residual income With No Selling To Your Family and Friends, NO Selling or Telling, Designed To Meet Today's Demands. Highly Effective System That Really Works!",
  "dtp": "February 6, 2013",
  "dtxt": "100 - 500",
  "n": "com.a1169367456511228af2d4516a.a55052279a",
  "new": "",
  "os": "2.2 and up",
  "pri": "Free",
  "purl": "",
  "rate": 5,
  "rct": 3,
  "sz": "511k",
  "t": "Build a Residual Income",
  "verc": "5242",
  "id": "com.a1169367456511228af2

There are 3179 apps that are categorized as Productivity, Business or Finance.

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 is 1 app.

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": [{"dct": {"$gte": 1000000}}, {"rate": {"$gt": 4}}]}

[
 {
  "_id": "56044568703498dd2a5242e6",
  "cadd": "",
  "cat": "Entertainment",
  "crat": "Unrated",
  "crt": "Wired DFW",
  "curl": "/store/apps/developer?id=Wired+DFW",
  "dct": 1000000,
  "desc": "Full-featured DIRECTV remote control! FYI - The PRO version is ON SALE for only $1.98! Click the \"More Applications\" button below.  Pro allows you to create a favorite channel \"guide\"... plus much more!  *** IF YOUR DIRECTV RECEIVERS ARE NOT CONNECTED TO YOUR HOME NETWORK THIS APP WILL NOT WORK!!! ** NOTE: This app only controls your DIRECTV receiver. It will not control any functions of your TV, such as volume and mute! Check the PRO version for more features...  Click the \"View More Applications\" button below! FEATURES -------- - Comprehensive full-featured remote control surface - \"Now Playing\" status bar notification - Auto-discovery of your receivers!  Zero Configuration! REQUIREMENTS ------------ - DIRECTV PLUS HD model HR20, HR21, HR22, HR23, HR24 or H21, H23, H24 (must be connected to your home network) - Wireless access to your home network for your Android device - Follow the \"HOW TO\" below! HOW TO CONFIGURE YOUR DIRECTV RECEIVER -------------------------------------- 1) Press \"Menu\" and select \"Parental, Fav's & Setup\" 2) Select \"System Setup\" 3) Select \"Whole-Home\" 4) Select \"Name Location\" and enter the name of the room you are in (for example: \"Living Room\" or \"Master Bedroom\" 5) Select \"External Device\" and make sure all three options are set to \"Allow\" That's it!  Start this app on your phone, and your receiver will be detected! Full-featured DIRECTV remote control!  Full control of your DIRECTV set top box via your touch screen Android device!!  *** IF YOUR DIRECTV RECEIVERS ARE NOT CONNECTED TO YOUR HOME NETWORK THIS APP WILL NOT WORK!!! Now features TheTVDB.com & TheMovieDB.org integration! TV shows AND movies are supported! HOW TO CONFIGURE YOUR DIRECTV RECEIVER -------------------------------------- 1) Press \"Menu\" and select \"Parental, Fav's & Setup\" 2) Select \"System Setup\" 3) Select \"Whole-Home\" 4) Select \"Name Location\" and enter the name of the room you are in (for example: \"Living Room\" or \"Master Bedroom\" 5) Select \"External Device\" and make sure all three options are set to \"Allow\" That's it!  Start this app on your phone, and your receiver will be detected! FEATURES -------- - Comprehensive full-featured remote control surface - View your recordings and click to resume playback. Long-click to start the recording from the beginning. - \"Now Playing\" status bar notification - Save your favorite channels for quick channel changing. Simply click the star on the \"Now Playing\" tab to add the channel to your favorites.  Then, click the yellow star tab to access your favorites list! - Auto-discovery of your receivers!  Zero Configuration! REQUIREMENTS ------------ - DIRECTV PLUS HD model HR20, HR21, HR22, HR23, HR24 or H21, H23, H24 (must be connected to your home network) Check here to see if your receivers are compatible, and if they require a network adapter from DIRECTV: http://support.directv.com/app/answers/detail/a_id/3057/~/are-my-receivers-compatible-for-whole-home-service - Wireless access to your home network for your Android device - Follow the \"HOW TO\" below! ** Wired DFW, LLC is not affiliated with DIRECTV. ** ** DIRECTV could stop any or all functions of this program at any time, download at your discretion ** ** DIRECTV is a registered trademark of DIRECTV, Inc. ** SEO ------- Satellite, remote, control, DIRECTV, DIRECT, TV, DIRECTTV",
  "dtp": "May 3, 2012",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.WiredDFW.DIRECTV.unWiredRemoteLite",
  "new": "v2.2.1 - Fixed bug when trying to access ad remover v2.2 - Fixed bug requiring user to \"select receiver\" when returning to remote - Added ability to remove ads from FREE! version v2.1.2 - App now goes straight to the remote control of the last receiver you selected when you launch the app - Added music information in \"now playing\" notification v2.1.1 - Made changes to receiver discovery. - Bug fixes v2.0.1 - Fixed layout bug on X-LARGE screens (large tablets)",
  "os": "2.1 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.4,
  "rct": 34795,
  "sz": "288k",
  "t": "DIRECTV Remote FREE!",
  "verc": "1336",
  "id": "com.WiredDFW.DIRECTV.unWiredRemoteLite-1336"
 },
 {
  "_id": "56044569703498dd2a524547",
  "cadd": "",
  "cat": "Finance",
  "crat": "Everyone",
  "crt": "ABN AMRO Bank N.V.",
  "curl": "/store/apps/developer?id=ABN+AMRO+Bank+N.V.",
  "dct": 1000000,
  "desc": "ABN AMRO's Mobiel Bankieren app puts your bank at your fingertips, 24/7. It allows you to easily access your current, savings and investment accounts. You can also personalise your app and make it even easier to use: enhance your accounts and payments with names and images. This allows you to see at a glance what you spend your money on and to quickly find what you are looking for. 5 reasons to use the

There are 917 apps.

Ten Apps with High Ratings and Many Downloads

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

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

[
 {
  "_id": "56044568703498dd2a524300",
  "cadd": "441 Blaine Ave\nMarion Ohio 43302",
  "cat": "Arcade",
  "crat": "Teen",
  "crt": "Rut Games",
  "curl": "/store/apps/developer?id=Rut+Games",
  "dct": 500,
  "desc": "★ ★ More bodies, less bull.★ ★  ★ Hardcore arcade zombie slaughter!   ★ Glorious explosions!  ★ Massive body count!   ★ Grenades and machine guns!   What more could you ask for in a 3D zombie game? Hard line communism! That's what! Alright?  You're still reading?  Really?   Let's Go, COMRADES!",
  "dtp": "March 8, 2013",
  "dtxt": "500 - 1,000",
  "n": "com.YannitellBrothers.CommieZombies",
  "new": "",
  "os": "2.0.1 and up",
  "pri": "Free",
  "purl": "",
  "rate": 3.6,
  "rct": 10,
  "sz": "17M",
  "t": "Commie Zombies",
  "verc": "7524",
  "id": "com.YannitellBrothers.CommieZombies-7524"
 },
 {
  "_id": "56044568703498dd2a524373",
  "cadd": "",
  "cat": "News & Magazines",
  "crat": "Teen",
  "crt": "ajppublishers",
  "curl": "/store/apps/developer?id=ajppublishers",
  "dct": 10000,
  "desc": "Get the latest Breaking Dawn Part 2 news and videos. Get Twilight Twitter and Facebook updates. Watch Breaking Dawn Part 2 trailers and other Twilight videos. See Twilight: Breaking Dawn Part 2 photos and get other media news about the film and stars such as Robert Pattinson, Kristen Stewart and Taylor Lautner. Get your Twilight: Breaking Dawn Part 2 fix all in one easy to use free app.",
  "dtp": "May 10, 2015",
  "dtxt": "10,000 - 50,000",
  "n": "com.a14468491355082a2c930ecb4a.a64478149a",
  "new": "Video feed fix News feed fix",
  "os": "2.3.3 and up",
  "pri": "$1.99",
  "purl": "",
  "rate": 4.3,
  "rct": 514,
  "sz": "4.1M",
  "t": "Breaking Dawn Part 2",
  "verc": "6319",
  "id": "com.a14468491355082a2c930ecb4a.a64478149a-6319"
 },
 {
  "_id": "56044568703498dd2a524388",
  "cadd": "",
  "cat": "News & Magazines",
  "crat": "Teen",
  "crt": "sportingapps",
  "curl": "/store/apps/developer?id=sportingapps",
  "dct": 1000,
  "desc": "Southampton Football News gives you all the latest information, transfers, Scores and results for Southampton Football club. This unofficial fan app gives you access to videos, photos and social media about SFC. Find out about the latest football transfer news and latest stories about the Saints and its current players like Jay Rodriguez and Manager Ronald Koeman.   Southampton FC are one of the top teams in English football and this free app will help you keep up-to-date with all the goings on during the current Premier league season and the FA Cup.",
  "dtp": "May 24, 2015",
  "dtxt": "1,000 - 5,000",
  "n": "com.a1570349524533090925fbed9a.a58619747a",
  "new": "Fixed video feed",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.3,
  "rct": 39,
  "sz": "6.3M",
  "t": "Southampton Football News",
  "verc": "5210",
  "id": "com.a1570349524533090925fbed9a.a58619747a-5210"
 },
 {
  "_id": "56044568703498dd2a524395",
  "cadd": "",
  "cat": "Sports",
  "crat": "Teen",
  "crt": "sportingapps",
  "curl": "/store/apps/developer?id=sportingapps",
  "dct": 1000,
  "desc": "Sunderland Football News gives you all the latest information, transfers, Scores and results for Sunderland Football club. This unofficial fan app gives you access to videos, photos and social media about SAFC. Find out about the latest football transfer news and latest stories about the black cats and its current players and Manager.   Sunderland AFC are one of the top teams in English football and this free app will help you keep up-to-date with all the goings on during the current Premier league season and the FA Cup.",
  "dtp": "May 24, 2015",
  "dtxt": "1,000 - 5,000",
  "n": "com.a1603181845246ddff6b4e19a.a03181954a",
  "new": "Video feed fix",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 3.7,
  "rct": 24,
  "sz": "7.1M",
  "t": "Sunderland Football News",
  "verc": "3187",
  "id": "com.a1603181845246ddff6b4e19a.a03181954a-3187"
 },
 {
  "_id": "56044568703498dd2a5243d2",
  "cadd": "",
  "cat": "Sports",
  "crat": "Teen",
  "crt": "123app4me",
  "curl": "/store/apps/developer?id=123app4me",
  "dct": 500,
  "desc": "The Youth Baseball Nationals is the premier youth baseball tournament in the nation! The Nationals is a week-long national tournament for 9U, 10U, 11U, 12U, 13U, 14U and 15U baseball teams. There’s nothing quite like the Nationals in youth baseball. The event features teams from all over the country, each week from the seven different age groups.  Key App Features: Live standings updates Updates and news through push notifications Maps to access important tournament locations Frequently asked questions Specials and discounts Share your tournament images More tournament info: Each team plays 6-10 games during the tournament. Schedules are carefully determined by placing teams with similar classification and skill level against each other during the 4 days of pool play to promote an even playing level with parity among participating teams. This is uni

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": {"$gt": 10000000}}]}

[
 {
  "_id": "56044593703498dd2a528f76",
  "cadd": "Gameloft S.E\n14 rue Auber,\n75009 Paris,\nFrance",
  "cat": "Casual Action & Adventure",
  "crat": "Everyone 10+",
  "crt": "Gameloft",
  "curl": "/store/apps/dev?id=6258770168633898802",
  "dct": 100000000,
  "desc": "Experience the brand-new Despicable Me: Minion Rush! Gru’s loyal, yellow, mischievous Minions are ready for their tastiest challenge yet: Collecting exotic fruits to make yummy jelly! Jump, roll, dodge and scramble against others in fun, fast-paced missions.   ALL THE FUN AND ANTICS OF DESPICABLE ME • Enjoy unpredictably hilarious Minion moments  • Perform despicable acts through hundreds of missions • Run through iconic locations that are full of surprises, secrets and tricky obstacles: Gru’s Lab, Gru’s Residential Area, El Macho’s Lair, Minion Beach and Super Silly Fun Land from Despicable Me • Customize your Minion with unique costumes, weapons, and power-ups • Battle Vector, El Macho, the Villaintriloquist and all the new villains exclusively created for the game AN INNOVATIVE AND ORIGINAL GAME • Encounter secret areas, unique boss fights and amazing power-ups  • Experience custom animation and voice-overs, and state-of-the-art 3D graphics • Enjoy multiple dynamic camera angles  • Engage in various bonus gameplay modes:     → Destroy things as Mega Minion    → Collect bananas while riding the Fluffy Unicorn    → Hang on to Gru’s Rocket for the ride of your life    → Unlock a new Power-Up and get ready for a Mission to the Moon! • Have fun with your friends! See their best scores during your run, send them funny Minion taunts and challenges to show them who’s going to win Minion of the Year! ______________________________________________ You can download and play this game for free. Please be informed that it also allows you to play using virtual currency, which can be acquired as you progress through the game, or by deciding to watch certain advertisements, or by paying with real money. Purchases of virtual currency using real money are performed using a credit card, or other form of payment associated with your account, and are activated when you input your Google Play account password, without the need to re-enter your credit card number or PIN.  In-app purchases can be restricted by adjusting the authentication settings within your Play Store settings (Google Play Store Home > Settings > Require authentication for purchases) and setting up a password for each purchase / Every 30 minutes or Never.  Disabling password protection may result in unauthorized purchases. We strongly encourage you to keep password protection turned on if you have children or if others could have access to your device. This game contains advertising for Gameloft’s products or some third parties which will redirect you to a third-party site. You can disable your device’s ad identifier being used for interest-based advertising in the settings menu of your device. This option can be found in the Settings app > Accounts (Personal) > Google > Ads (Settings and Privacy) > Opt out of interest-based ads. Certain aspects of this game will require the player to connect to the Internet.  _____________________________________________ 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 upcoming titles. Discover our blog at  http://glft.co/Gameloft_Official_Blog  for the inside scoop on everything Gameloft. Privacy Policy :  http://www.gameloft.com/privacy-notice/ Terms of Use :  http://www.gameloft.com/conditions/ End User License Agreement :  http://www.gameloft.com/eula/",
  "dtp": "September 16, 2015",
  "dtxt": "100,000,000 - 500,000,000",
  "n": "com.gameloft.android.ANMP.GloftDMHM",
  "new": "Go back to school with the Minions in this new update for Despicable Me: Minion Rush! • Now 4 MORE COSTUMES will power up your Gadgets • Outrun the clock in the challenging new TIME-ATTACK MODE in Minion Races • MINION RACES are now headed to the Mall • BACK-TO-SCHOOL SPECIAL EVENT: Gear up for class by grabbing Backpacks, Notebooks, and Lunchboxes • SCOOTER MINI-GAME: Pull off some speedy stunts and collect bonus back-to-school items • 15 NEW LEVELS in the Jelly Lab",
  "os": "2.3 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.gameloft.com/privacy-notice/&sa=D&usg=AFQjCNGX3aQPRQ30ew0bAf31IqNsPjF4eQ",
  "rate": 4.4,
  "rct": 7679653,
  "sz": "",
  "t": "Despicable Me",
  "verc": "3017",
  "id": "com.gameloft.android.ANMP.GloftDMHM-3017"
 },
 {
  "_id": "56044593703498dd2a528f80",
  "cadd": "Gameloft S.E\n14 rue Auber,\n75009 Paris,\nFrance",
  "cat": "Casual",
  "crat": "Everyone 10+",
  "crt": "Gameloft",
  "curl": "/store/apps/dev?id=6258770168633898802",
  "dct": 50000000,
  "desc": "Embark on a fun and frozen journey through the Ice Age universe! In his hunt for his favourite acorn, across the froze

There are 2 apps.

Apps Downloaded Frequently From an App

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}}, {"cadd": {"$ne": ""}}]}

[
 {
  "_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": "56044593703498dd2a528dfc",
  "cadd": "Perth, Western Australia",
  "cat": "Casual Action & Adventure",
  "crat": "Everyone",
  "crt": "Ezone.com",
  "curl": "/store/apps/developer?id=Ezone.com",
  "dct": 5000000,
  "desc": "Like platform games? Like running games? Well, you're gonna luv Diversion: 200+ levels, 7 Worlds, 700+ characters - one touch! Come and try a brand new game genre: the \"Platform Runner\". A big thank you to the more than 5 million players who have downloaded and made Diversion so popular on Android!!! You guys rock!! Keep the great feedback coming - it really inspires us to keep the updates coming! - Challenging gameplay requires timing and puzzle solving - Cheat codes for in-game prizes: gem packs, characters, levels! - Daily Bonus! Earn gems and characters every day you play! - Boss battles! - 700+ fully-animated playable characters to unlock and collect - 200+ Levels - 7 Unique 3D Worlds - 3rd person camera: see all the action - Different every time you play! - Any gem or token pack purchase removes all in-game ads… forever!!! - Built for NVIDIA Tegra with real-time shadows and physics powered by PhysX - Bluetooth controller support - New ways to earn free save tokens - Tablet support - Compete against your Google+ buddies! - Google Play Leaderboards - Google Play Achievements ★★ Hover World Preview level!!! Cruise around on your hover board collecting gems, or jump off and run around in this free roaming world. Check out  http://facebook.com/ezonecom  for details! ★★ Be amazed at what you can do : run, jump, climb, hang, swim, zip, slide, and even fly! As you progress through levels you'll unlock more challenging gameplay and hazards, including: spikes, chasms, zip-lines, slides, ledges, holes, buttons, spiderbots, bouncer bombs, water, laser walls, meteors, security drones, aliens, mutant sharks, chompers, stompers, lava, steam vents, blast vents, reversers, stoppers, portals, spike rollers, and more! 175 challenging levels will require timing and puzzle solving skills to complete and unlock hundreds of playable characters including: Ninja, Alien, Rocket, Karate, Robo, 60s, Zombie, Burglar, Tiger, Egyptian and even the Freaky Chicken and Future Banana! Will th

There are 17 apps.

Title and Creator Address of Apps with High Ratings and Many Downloads

11- Find the title, category, download count, and rating of apps with download count of 1,000,000 or more but have no privacy statements?

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

[
 {
  "_id": "56044568703498dd2a524297",
  "cadd": "",
  "cat": "Tools",
  "crat": "Unrated",
  "crt": "Vignesh",
  "curl": "/store/apps/developer?id=Vignesh",
  "dct": 1000000,
  "desc": "Making caller ID fun with stickers. Get Information about the caller along with his customised caller screen and Facebook details. Are you getting calls from unknown number? Do you want to find from where that person is calling? Now you can use Mobile Number Tracker to find from which state/telecom operator a mobile number belongs to. It shows caller info during incoming call. You can also view the details of mobile number in the call log. FEATURES: - Locate phone number area and state. - Find address from map. - Analyse you call logs information - View call logs along with operators information - Sleek UI - No Internet connection required - Updated Mobile number database.  - Regular updates - Shows Caller Information during the call. - Customize Caller Info display duration Supports USA and India. Other countries will be added soon. The MNP ported numbers are not traceable by the app. - This app cannot show you the physical location of the caller. - MNT(MobileNumberTracker) may also use Google Analytics to collect anonymous usage data in order to help build improvements to the app.",
  "dtp": "October 18, 2014",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.ViQ.Productivity.MobileNumberTracker",
  "new": "2.1 * Show your cool customised call screen to your friends via Call Stickers!!! 2.0 * Link Facebook profile to phone numbers. 1.8.2 *Added map to search screen. 1.8.0 *Map search screen added *Added new operator codes for India 1.7.4 *fixed date range issues of Analytic screen Thanks for trying out our app. Your suggestions are most welcome. P.S: The MNP ported numbers are not traceable by the app.",
  "os": "2.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 3.9,
  "rct": 21426,
  "sz": "4.6M",
  "t": "Mobile Number Tracker",
  "verc": "6933",
  "id": "com.ViQ.Productivity.MobileNumberTracker-6933"
 },
 {
  "_id": "56044568703498dd2a5242e6",
  "cadd": "",
  "cat": "Entertainment",
  "crat": "Unrated",
  "crt": "Wired DFW",
  "curl": "/store/apps/developer?id=Wired+DFW",
  "dct": 1000000,
  "desc": "Full-featured DIRECTV remote control! FYI - The PRO version is ON SALE for only $1.98! Click the \"More Applications\" button below.  Pro allows you to create a favorite channel \"guide\"... plus much more!  *** IF YOUR DIRECTV RECEIVERS ARE NOT CONNECTED TO YOUR HOME NETWORK THIS APP WILL NOT WORK!!! ** NOTE: This app only controls your DIRECTV receiver. It will not control any functions of your TV, such as volume and mute! Check the PRO version for more features...  Click the \"View More Applications\" button below! FEATURES -------- - Comprehensive full-featured remote control surface - \"Now Playing\" status bar notification - Auto-discovery of your receivers!  Zero Configuration! REQUIREMENTS ------------ - DIRECTV PLUS HD model HR20, HR21, HR22, HR23, HR24 or H21, H23, H24 (must be connected to your home network) - Wireless access to your home network for your Android device - Follow the \"HOW TO\" below! HOW TO CONFIGURE YOUR DIRECTV RECEIVER -------------------------------------- 1) Press \"Menu\" and select \"Parental, Fav's & Setup\" 2) Select \"System Setup\" 3) Select \"Whole-Home\" 4) Select \"Name Location\" and enter the name of the room you are in (for example: \"Living Room\" or \"Master Bedroom\" 5) Select \"External Device\" and make sure all three options are set to \"Allow\" That's it!  Start this app on your phone, and your receiver will be detected! Full-featured DIRECTV remote control!  Full control of your DIRECTV set top box via your touch screen Android device!!  *** IF YOUR DIRECTV RECEIVERS ARE NOT CONNECTED TO YOUR HOME NETWORK THIS APP WILL NOT WORK!!! Now features TheTVDB.com & TheMovieDB.org integration! TV shows AND movies are supported! HOW TO CONFIGURE YOUR DIRECTV RECEIVER -------------------------------------- 1) Press \"Menu\" and select \"Parental, Fav's & Setup\" 2) Select \"System Setup\" 3) Select \"Whole-Home\" 4) Select \"Name Location\" and enter the name of the room you are in (for example: \"Living Room\" or \"Master Bedroom\" 5) Select \"External Device\" and make sure all three options are set to \"Allow\" That's it!  Start this app on your phone, and your receiver will be detected! FEATURES -------- - Comprehensive full-featured remote control surface - View your recordings and click to resume playback. Long-click to start the recording from the beginning. - \"Now Playing\" status bar notification - Save your favorite channels for quick channel changing. Simply click the star on the \"Now Playing\" tab to add the channel to your favorites.  Then, click the yellow star tab to access your favorites list! - Auto-discovery of your receivers!  Zero Configuration! REQUIREMENTS ------------ - DIRECTV PLUS HD model HR20, HR21, HR22, HR23, HR24 or H21, H23, H24 (must be connect

There are 913 apps.

Ten Apps with High Download Counts, but no Privacy Statements

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

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

[
 {
  "_id": "56044568703498dd2a5242db",
  "cadd": "",
  "cat": "Personalization",
  "crat": "Everyone",
  "crt": "Photo Frames And Effects",
  "curl": "/store/apps/developer?id=Photo+Frames+And+Effects",
  "dct": 10000,
  "desc": "Be the part of animal world and enjoy decorating your images with Wildlife Photo Frames. With this powerful tool you can beautify all your photos and make the best moments of your life unforgettable. Add some new life to your old pictures with amazing new animal species. This is a fantastic opportunity to show everybody your artistic skills and your natural talent for photo editing. - Select a photo from the gallery of your phone and use this pic frame to decorate it!  - Capture a new image with your camera and apply a cool frame to it!  - Rotate, scale, zoom in, zoom out or drag the photo to fit the frame as you like!  - Wildlife Photo Frames app supports all screen resolutions of mobile and tablet devices.  - Save your new picture and share it on social networks like Facebook or Twitter!  - Get this best frame app for Android™ and you'll have the most beautiful pictures!  Try these animal pic frames to make your photos look amazing and you will be more than satisfied. If you need some photo fun, you can edit all the pictures you have and make them unique. Wherever you go, any time and any moment, just take pic from your camera or import it from a photo gallery and decorate with these amazing frames ! Now you can save your sweet memories in a different, beautiful,and stylish way. So, don't hesitate,  download “Wildlife Photo Frames” free app for Android™  and decorate all your images the way you like.  *Android is a trademark of Google Inc.",
  "dtp": "September 1, 2015",
  "dtxt": "10,000 - 50,000",
  "n": "com.WildlifePhotoFrames.PhotoFramesAndEffects",
  "new": "",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.3,
  "rct": 112,
  "sz": "28M",
  "t": "Wildlife Photo Frames",
  "verc": "6885",
  "id": "com.WildlifePhotoFrames.PhotoFramesAndEffects-6885"
 },
 {
  "_id": "56044568703498dd2a524317",
  "cadd": "12F, No. 34, Sec. 5, Nanjing E. Rd., Taipei City 105, Taiwan",
  "cat": "Tools",
  "crat": "Everyone",
  "crt": "Sam Lu",
  "curl": "/store/apps/dev?id=7252933074709348199",
  "dct": 50000,
  "desc": "App Usage (a.k.a Batch Uninstaller) is the most easy to use but powerful application management app. It provides the following key features: ★  Check phone history : gather counts of you checked the phone ★  Show app usage history : gather the usage time about apps that you used ★  Track all installs : keep track of all installs and uninstalled apps ★  Manage apps : 1-tap to uninstall apps, sort apps by various options ★  Over-use reminder : remind when you spend on phone or apps for a long time ★  App install reminder : notify when apps installed and the summary of daily installed apps ★  Most used apps  - show most used apps on widgets or a notification FEATURES ★ Phone/App usage history ★ Most used apps ★ Over-use reminder ★ App installation history ★ App install reminder ★ Keep track of uninstalled apps so you can install them later ★ Batch uninstall apps ★ Root uninstaller, 1-tap to uninstall apps, rooted device required ★ Add personal notes for each app ★ Sort apps by name, usage time, access count, update time or size ★ Show apps in multi-column view ★ Batch clear apps cache or data ★ Batch show the App info window of selected apps ★ Batch view apps on Google Play ★ Easy search apps by name ★ Share the apps list with friends ★ Support Android 2.3 ~ 6.x ► CHECK PHONE HISTORY Do you know how many times a day that you check your phone? This function shows the daily count that you checked your phone in either a bar chart or calendar view. ► SHOW APP USAGE HISTORY Do you know how much time you spend on an app? Do you know the total use time of a day or average use time of an app? This function lists the usage time of apps by you preferred sorting order. This usage information is helpful for you to check which apps should be uninstalled as they are not used. It can also be used for spying whether an app has been used by someone else. ► TRACK ALL INSTALLS Do you know which app has been installed or uninstalled without getting your confirmation? Do you know how frequent updates of an app? This function tracks and lists the history of all installed and uninstalled apps by you preferred sorting order. It's convenient for you to track how many apps updated in a day, and how frequent updates of an app. ► MANAGE APPS Do you know which apps that are not used for a long time? You can get more available space by uninstalling apps, but which one is bloatware? This function lists apps by app name, usage time, access count, update time or size, and allows you to uninstall apps easily and quickly. ► OVER-USE REMINDER This function reminds you when you spend on phone or apps for a long time. ► APP INSTALL REMINDER This function reminds you when an app installed and the s

There are 3202 Apps