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": "56044594703498dd2a5290a7",
  "n": "com.gau.go.launcherex.gowidget.newcalendarwidget.fullscreen"
 },
 {
  "_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": "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"
 },
 {
  "_id": "56044594703498dd2a5290ab",
  "n": "com.gau.go.launcherex.gowidget.weatherwidget"
 },
 {
  "_id": "56044594703498dd2a5290a6",
  "n": "com.gau.go.launcherex.gowidget.gopowermaster"
 },
 {
  "_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"
 }
]

There are 40 apps.

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

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

[
 {
  "_id": "56044588703498dd2a528196",
  "cadd": "",
  "cat": "Productivity",
  "crat": "Everyone",
  "crt": "Notes",
  "curl": "/store/apps/developer?id=Notes",
  "dct": 50000000,
  "desc": "ColorNote® is a simple and awesome notepad app. It gives you a quick and simple notepad editing experience when you write notes, memos, e-mails, messages, shopping lists and to-do lists. Taking notes with ColorNote® Notepad is easier than any other notepad or memo pad app. * Notice * - If you cannot find the widget, then please read the FAQ below. - When you're finished using the notepad, an automatic save command preserves your individual note. * Product Description * ColorNote® features two basic note taking formats, a lined-paper styled text option, and a checklist option. Add as many as you want to your master list, which appears on the app's home screen each time the program opens. This list may be viewed in traditional ascending order, in grid format, or by note color. - Taking a Note - Serving as a simple word processing program, the text option allows for as many characters as you're willing to type. Once saved, you can edit, share, set a reminder, or check off or delete the note through your device's menu button. When checking off a text note, the app places a slash through the list's title, and this will be displayed on the main menu. - Making To-do List or Shopping List - In the checklist mode, you can add as many items as you'd like and arrange their order with drag buttons activated in the edit mode. After the list is finished and saved, you may check or uncheck each line on your list with a quick tap, which will toggle a line slash. If all items have been checked, then the list's title is slashed as well. * Features * - Organize notes by color (color notebook) - Sticky note memo widget (Put your notes on your home screen) - Checklist notes for To do list & Shopping list. (Quick and simple list maker) - Checklist notes to get things done (GTD) - Organize your schedule by note in calendar - Write a diary and journal in calendar - Password Lock note : Protect your notes with passcode - Secured backup notes to SD storage - Supports online back up and sync. You can sync notes between phone and tablet. - Reminder notes on status bar - List/Grid View - Search notes - Notepad supports ColorDict Add-on - Powerful task reminder : Time Alarm, All day, Repetition.(lunar calendar) - Quick memo / notes - Wiki note link : [[Title]] - Share notes via SMS, e-mail or Twitter * Online backup and sync cloud service * - Notes will be encrypted before uploading notes by using the AES standard, which is the same encryption standard used by banks to secure customer data. - It does not send any of your notes to the server without you signing in. - Sign-in with Google or Facebook. * Permissions * - Internet Access: For online backup & sync notes - Modify/delete SD card contents: For backup notes to SD card - Prevent phone from sleeping, control vibrator, automatically start at boot: For reminder notes * FAQ * Q: How do you put a sticky note widget on the home screen? A: Go to the home screen and hold down your finger on an empty space and choose widget, Color Note will then be desplayed so you can stick on the page.  Q: Why don't the widget, the alarm and notes remider functions work? A: If the app is installed on the SD card, your widget, reminder, etc. will not work properly because Android doesn't support these features when installed on an SD card! If you have already moved the app to an SD card, but want those features, then you have to move the app back on the device and reboot your phone. Settings - Applications - Manage Applications - Color Note - Move to Device Q: Where are backed up notes data on the SD card? A: '/data/colornote' or '/Android/data/com.socialnmobile.dictapps.notepad.color.note/files' on SD card  Q: I forgot my master password. How can I change it? A: Menu → Settings → Master Password → Menu Button → Clear Password. You will lose your current locked notes when you clear the password! Q: How can I create todo list note? A: New - Select checklist note - Put items - Save. Tap an item to strikethrough.",
  "dtp": "May 17, 2015",
  "dtxt": "50,000,000 - 100,000,000",
  "n": "com.socialnmobile.dictapps.notepad.color.note",
  "new": "** If you cannot find widgets, you have to move the app back to device in application settings and reboot your phone! ** The best way to report bugs of the update is to send an email. 3.9.82 - Android 5.0, 5.1 Lollipop bugs fixed - Samsung Galaxy Lollipop crash bugs fixed. (A reboot can be required) 3.9.60 - Summer/Winter time bug fixed. - Open the drawer by swiping from the left edge of the screen. 3.9.13 - Auto link setting changed : Settings -> Auto Link -> Auto link phone number",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.colornote.com/privacy-policy.html&sa=D&usg=AFQjCNEz_86oQyLakpQLy4T0s_us6bISUg",
  "rate": 4.5,
  "rct

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

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": "56044568703498dd2a5243f8",
  "cadd": "",
  "cat": "Business",
  "crat": "Unrated",
  "crt": "NewCenturyEdge",
  "curl": "/store/apps/developer?id=NewCenturyEdge",
  "dct": 5,
  "desc": "Team Reyes is a Multi-Award Winning Real Estate Team based at RE/MAX Top Producers in Diamond Bar, CA. We specialize in Buying, Selling, Commercial and Investment Properties. We are professional, fast, and thorough with our work. Team Reyes treats their client's time and investments with special care.",
  "dtp": "March 30, 2015",
  "dtxt": "5 - 10",
  "n": "com.a262949193547bbb3aa0a9b6a.a55002610a",
  "new": "",
  "os": "2.3.3 and up",
  "pri": "$7.99",
  "purl": "",
  "rate": 0,
  "rct": 0,
  "sz": "4.2M",
  "t": "Team Reyes Homes",
  "verc": "6484",
  "id": "com.a262949193547bbb3aa0a9b6a.a55002610a-6484"
 },
 {
  "_id": "56044568703498dd2a524430",
  "cadd": "PO Box 5978 Basildon Essex SS14 0WD",
  "cat": "Business",
  "crat": "Unrated",
  "crt": "ALF Media",
  "curl": "/store/apps/developer?id=ALF+Media",
  "dct": 1000,
  "desc": "Connect with the hydraulic industry with Completely Hydraulic. Use the Car Locator and Barcode Scanner amongst others as useful tools in your day to day business.",
  "dtp": "December 3, 2014",
  "dtxt": "1,000 - 5,000",
  "n": "com.a572548969528fc802382cc8a.a96958648a",
  "new": "",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.7,
  "rct": 13,
  "sz": "4.4M",
  "t": "Completely Hydraulic",
  "verc": "6",
  "id": "com.a572548969528fc802382cc8a.a96958648a-6"
 },
 {
  "_id": "56044568703498dd2a52444e",
  "cadd": "",
  "cat": "Business",
  "crat": "Unrated",
  "crt": "Proapptive",
  "curl": "/store/apps/developer?id=Proapptive",
  "dct": 500,
  "desc": "The Cork - a bar for every occasion. The Cork App brings you all the latest Cork information right to your phone: Facebook & Twitter feeds, latest news and events, our menu and opening hours PLUS exclusive access to discount vouchers only available through the app. Located in the heart of the bustling city of Bath, The Cork offers you the perfect place to socialise, relax and simply enjoy the surroundings in the upstairs bar, out on the terrace or in the stylish vaults bar.",
  "dtp": "July 21, 2014",
  "dtxt": "500 - 1,000",
  "n": "com.a68005602250251ef0c2cf24a.a22739136a",
  "new": "New design and new features",
  "os": "2.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 3,
  "rct": 7,
  "sz": "8.1M",
  "t": "The Cork",
  "verc": "284",
  "id": "com.a68005602250251ef0c2cf24a.a22739136a-284"
 },
 {
  "_id": "56044569703498dd2a524813",
  "cadd": "",
  "cat": "Business",
  "crat": "Everyone",
  "crt": "Starline Techno",
  "curl": "/store/apps/developer?id=Starline+Techno",
  "dct": 1000,
  "desc": "Agroya Bullion Corporation (ABC) is a leading company in Pune, India which deals in bullion, specializing in bars and coins of various precious metals like Gold and Silver. Being a company which facilitates investment in precious metals, ABC endeavors to combine our technical and market experience with hard work and dedication to provide our clients the ability to make informed investment decisions.",
  "dtp": "September 7, 2015",
  "dtxt": "1,000 - 5,000",
  "n": "com.agroyabullion",
  "new": "",
  "os": "2.2 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.4,
  "rct": 42,
  "sz": "1.9M",
  "t": "Agroya Bullion Corporation",
  "verc": "7832",
  "id": "com.agroyabullion-7832"
 },
 {
  "_id": "56044569703498dd2a524824",
  "cadd": "",
  "cat": "Business",
  "crat": "Everyone",
  "crt": "ahex technologies",
  "curl": "/store/apps/developer?id=ahex+technologies",
  "dct": 100,
  "desc": "Don't worry for business cards to be creased and dirty.   Card-e-Holder can make collecting and keeping visiting cards  safer and smarter than ever before and it  can also be used to retrieve  business information about a company or individual with different search option available.  Card-e-Holder app is designed specially for business professionals and can be widely used for personal and office purpose. Card-e-Holder is  very helpful as it can hold all business cards and  you can carry  all business cards along. You can store name, designation, company and note along with snapshot of business cards from gallery or by taking photo with camera or with scanned copy. It will help you to keep all your business cards safely and you can search them in no time. Eventually cards are prevented from misplacement and  sticking by welted pockets.",
  "dtp": "May 2, 2015",
  "dtxt": "100 - 500",
  "n": "com.ahextechnologies.visitingcardmanager",
  "new": "Added Email Address and Phone Number Fields in Add new card screen. You can now search your cards by email and by phone number.",
  "os": "4.0 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://ahextechnologies.com/web_findme/privacy.html&sa=D&usg=AFQjCNGk_hZkOtKONLxyflCrHR0iEKg0QA",
  "rate": 4.2,
  "rct": 4,
  "sz": "2.3M",
  "t": "Card-e-Holder",
  "verc": "9943",
  "id": 

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": "56044569703498dd2a524975",
  "cadd": "",
  "cat": "Lifestyle",
  "crat": "Everyone",
  "crt": "Alarm.com Mobile",
  "curl": "/store/apps/developer?id=Alarm.com+Mobile",
  "dct": 1000000,
  "desc": "With an Alarm.com-enabled security system, you can monitor and control your home or business in real-time and from anywhere.  Alarm.com’s interactive security, video monitoring, energy management, and home automation solutions give you instant awareness and remote control for the places you care about most.   Note: This app requires a compatible system and an interactive Alarm.com service plan. Feature availability varies based on system, equipment, and service plan.  Visit www.alarm.com for more information. Remote features: ✓ See what’s happening at your property  ✓ Arm or disarm your security panel ✓ Watch live video and recorded clips from your security cameras ✓ Turn on or off lights ✓ Set the ideal temperature  ✓ Lock or unlock doors    ✓ View images of important activity captured by Alarm.com image sensors ✓ Search your complete system event history ✓ And much more!      With Alarm.com, you can also receive real-time email, text message, and push notifications for the specific events that matter to you.  Beyond important emergency related events, you can also immediately know when: • Your kids get home from school • You left for work or vacation and forgot to arm your system  • The housekeeper arrives or leaves • The garage door is left open • The dog walker or cat sitter arrives  • There's flooding or a water leak in your basement • Your children open your medicine or liquor cabinets • Someone changes your thermostat settings  • Your security system is disarmed (and who disarmed it) • Someone attempts to log into your account • And much more!",
  "dtp": "September 22, 2015",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.alarm.alarmmobile.android",
  "new": "• Minor fixes/enhancements",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.alarm.com/privacy_policy.aspx&sa=D&usg=AFQjCNED4K7JDG19INn6lIKWYVzEaTyBPg",
  "rate": 4.4,
  "rct": 14639,
  "sz": "Varies with device",
  "t": "Alarm.com",
  "verc": "1399",
  "id": "com.alarm.alarmmobile.android-1399"
 },
 {
  "_id": "56044569703498dd2a52497b",
  "cadd": "",
  "cat": "Trivia",
  "crat": "Everyone",
  "crt": "Brett Plummer",
  "curl": "/store/apps/developer?id=Brett+Plummer",
  "dct": 1000000,
  "desc": "Bible Trivia game will quiz your knowledge of the holy book.  Some of the questions are bible quotes in which you choose the word or phrase that finishes the well-known Bible quotation.  Other questions center around the people and events that take place in the Bible: Jesus Christ, Noah, Moses, David, Peter, David, the Virgin Mary, and many more.  A good game to play around Christmas, Easter, or any time of year. Profile info optional, just save a Profile and play for Free! Also check out my \"Bible Quiz - Who Am I?\" Android app. Updated for gingerbread and jellybean.",
  "dtp": "July 25, 2015",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.alaskajim.bible",
  "new": "February 2015: Update for Lollipop September 2014: Update for Kitkat June 2014 - Update to show Incorrect Answers properly on newer devices.",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://apps-quizzes-trivia.blogspot.com/p/privacy-policy.html&sa=D&usg=AFQjCNHO4t59tZc8n19YPdHTvx_1XWjTcw",
  "rate": 4.3,
  "rct": 4382,
  "sz": "6.4M",
  "t": "Bible Trivia",
  "verc": "9579",
  "id": "com.alaskajim.bible-9579"
 },
 {
  "_id": "56044569703498dd2a524a21",
  "cadd": "Palace Mansions, Earsby Street, London, W14 8EQ",
  "cat": "Productivity",
  "crat": "Everyone",
  "crt": "Marton Veges",
  "curl": "/store/apps/developer?id=Marton+Veges",
  "dct": 1000000,
  "desc": "It has the best graphing experience available on the Play Store. Draw functions, find intersections and show a table of values of the functions with an easy to use interface.   Use the following unique features to help you with your Calculus and Algebra class: *Symbolic Differentiation *Definite Integrals *Calculate Taylor-series *Solve Equations Algeo has every feature a scientific calculator needs: *Trigonometric and Hyperbolic Functions *Radians and Degree Support *Result History *Variables *Scientific Notation *Supports Landscape Mode If you need help press Menu button -> Help or send an e-mail! If trigonometric functions give an incorrect answer, make sure you are in the correct angle mode.  You can check it in the upper right corner. To change it press more->DEG/RAD.",
  "dtp": "June 16, 2015",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.algeo.algeo",
  "new": "Fixed unreadable menu on Android 5.1 Added thousands separator",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "",
  "rate": 4.3,
  "rct": 13832,
  "sz": "Varies with device",
  "t": "Algeo Graphing Calculator",
  "verc": "329",
  "id": "com.algeo.algeo-3

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": "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 unique to the Nationals. We make every effort to create an atmosphere where every team can compete, regardless of skill level. Our objective is to promote an equal playing level within the field during the pool play portion of the tournament. Teams are then seeded for the elimination round based on their performance and strength of schedule.",
  "dtp": "June 4, 2015",
  "dtxt": "500 - 1,000",
  "n": "com.a1ec5cee3_b7e7_474c_ae87_f6706e546661",
  "new": "",
  "os": "4.1 and up",
  "pri": "$7.99",
  "purl": "",
  "rate": 3,
  "rct": 6,
  "sz": "30M",
  "t": "2015 Youth Baseball Nationals",
  "verc": "8187",
  "id": "com.a1ec5cee3_b7e7_474c_ae87_f6706e546661-8187"
 },
 {
  "_id": "56044568703498dd2a5243fc",
  "cadd": "",
  "cat": "Sports",
  "crat": "Teen",
  "crt": "sportingapps",
  "curl": "/store/apps/developer?id=sportingapps",
  "dct": 1000,
  "desc": "Newcastle Football News gives you all the latest information, transfers, Scores and results for Newcastle United Football club. This unofficial fan app gives you access to videos, photos and social media about NUFC. Find out about the latest football transfer news and latest stories about the Magpies and its current players and Manager.   Newcastle United 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. Download this free toon army app today!",
  "dtp": "June 29, 2015",
  "dtxt": "1,000 - 5,000",
  "n": "com.a248218658520d4ee04aec54a.a25507330a",
  "new": "Fixed video feed and icon change",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.2,
  "rct": 13,
  "sz": "4.1M",
  "t": "Newcastle Football News",
  "verc": "3171",
  "id": "com.a248218658520d4ee04aec54a.a25507330a-3171"
 },
 {
  "_id": "56044569703498dd2a524814",
  "cadd": "57 Al-Faya AlRiyad Kingdom of Saudi Arabia",
  "cat": "Action",
  "crat": "Teen",
  "crt": "Absolute Game Studio",
  "curl": "/store/apps/developer?id=Absolute+Game+Studio",
  "dct": 100000,
  "desc": "Have you wanted an exclusive dino pet Trex from the jurassic world.  Here is your virtual dinosaur, the most deadly Trex to create havoc from prehistoric times. This wild dinosaur simulator brings you a terrifying dino quest for  some exquisite hunting expedition in dense African jungles.  Destroy and attack  diplodocus, pterandon and triceratops.  Embark on the safari survival adventure in jungles of Africa.  Hunt down the docile ankylosaurus ,brontosaurus and spinosaur,   to quench the hunger of the terrifying Tyrannosaurus.  The paleontologists would never believe that the era of dinosaurs has returned. This dinosaur simulator portrays the african jungle filled with prehistoric dinos turning it into the dinosaur world. All the wild animals, cheetah, lion are fighting for their space. This vicious jurassic beast is ready to hunt and eat all kinds of docile and deadly beasts carnivores and herbivores. The vicious apatosauris, allosaurus and ankylosaurus are hidden in further deadly levels. Beware of the jungle hunters that have deadly aresenal  to kill the powerful dinosaur on encounter. Select your dinosaur from Trex ( Tyrannosaurus), brontosaurus or Triceratops and match the speed and strength of present time carnivore animals.  Features: •\tHuge African safari Jungle Map •\tAwesome action packed levels. •\tFatal attacks with arsenals, bazooka and fights between wild jurassic beasts •\tLargest collection cretaceous dinosaurs  •\tBonus level fight with pterandon, diplodocus and lion •\tKeep a record of your hunting success.",
  "dtp": "March 18, 2015",
  "dtxt": "100,000 - 500,000",
  "n": "com.ags.dinosaur.chase.deadly.attack",
  "new": "",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 3.8,
  "rct": 1100,
  "sz": "39M",
  "t": "Dinosaur Chase: Deadly Attack",
  "verc": "1346",
  "id": "com.ags.dinosaur.chase.deadly.attack-1346"
 },
 {
  "_id": 

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": "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 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": "56044568703498dd2a5243a8",
  "cadd": "",
  "cat": "Entertainment",
  "crat": "Unrated",
  "crt": "GO APPS",
  "curl": "/store/apps/developer?id=GO+APPS",
  "dct": 1000000,
  "desc": "Crush Secrets Guide This is an Unofficial Candy Crush  Secrets Guide,!!! This app  is designed to bring the latest tips and tactics on candy crush and secrets that no one wants to tell you about. What is included: -best strategies + tactics -full video tutorials all 500+ levels  - hints  -tricks -unlimited moves - unlimited moves zero -boosters -news  -wikipedias etc Download Crush Secrets Guide Now to be the best players that everyone envy I hope you can get useful secrets and guide 100% free. This is no candy in crush except many useless cheats. ******* Top Reviews:***** \" The best candy secrets that i ever seen and crush in any saga....and it is totally FREE\" \" I can now be the best candy  player in my crush team\" \" Very informative\" Legal Notice: This app is not authorized or created by the authors or legal representatives of \"Candy Crush Saga\". This application complies with US Copyright law guidelines of \"fair use\". If you feel there is a direct copyright or trademark violation that doesn't follow within the \"fair use\" guidelines please contact us to discuss. This app provides an interface to interact, browse and watch YouTube video content. All characters and their names, places, events and all other aspects concerning the game are the property of their respective owners. All trademark and copyright concerning the game series are the property of their respective owners. We make no claim to and do not have any rights to any of the foregoing. Images in this application are used only to convey what the application is about. If you believe that there has been a contravention of your proprietary rights then email us using Email Developer below. If you are a copyright owner and you feel that our fan application violates your terms, please contact us first before submitting complaint to Google Play. Disclaimer: \"This app will add a new icon on your home screen that links to a Games, Apps and Android Tricks mobile web page. If you do not want to use this awesome page, you can either ignore it or delete it. If you do use it, we get help promoting this app and make a few cents, it will also help us keep developing more great apps. \"",
  "dtp": "January 13, 2014",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.a17350648352d48db91a4413a.a89436633a",
  "new": "",
  "os": "2.2 and up",
  "pri": "Free",
  "purl": "",
  "rate": 3.7,
  "rct": 5450,
  "sz": "1.4M",
  "t": "Crush Secrets Guide",
  "verc": "7660",
  "id": "com.a17350648352d48db91a4413a.a89436633a-7660"
 },
 {
  "_id": "56044569703498dd2a524867",
  "cadd": "Calle Manufactura, 2\nPiso 1, Puerta C\n41927 Mairena del Aljarafe (Sevilla)",
  "cat": "Racing",
  "crat": "Everyone",
  "crt": "AxesInMotion Racing",
  "curl": "/store/apps/dev?id=7842996855899014066"

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": "56044569703498dd2a525033",
  "cadd": "",
  "cat": "Communication",
  "crat": "Everyone",
  "crt": "Multimedios 506",
  "curl": "/store/apps/developer?id=Multimedios+506",
  "dct": 100000,
  "desc": "Contiene los siguiente periódicos de Costa Rica: -La Nación (Acceso Limitado) -La Extra -La Teja (Acceso Limitado) -La Prensa Libre -La República (Acceso Limitado) -El Financiero (Acceso Limitado) -La Gaceta -Medios Universitarios -Diarios Digitales y Revistas -Noticieros de Radio y TV -Busco Empleo -Loterías ***Si conocen de algún otro medio, escríbanme y con gusto lo agregamos*** *****ACLARACIÓN: Esta aplicación no tiene relación con ninguno de los diarios que en ella se encuentran, la actualización y producción es total y absolutamente propiedad de las mismas, aquí simplemente las agrupamos y ordenamos de manera que sea más fácil para el lector tenerlas a la mano y en una misma aplicación.*****",
  "dtp": "September 1, 2015",
  "dtxt": "100,000 - 500,000",
  "n": "com.andromo.dev34618.app192937",
  "new": "Mejoras generales",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.4,
  "rct": 1550,
  "sz": "3.4M",
  "t": "Diarios de Costa Rica y más",
  "verc": "7751",
  "id": "com.andromo.dev34618.app192937-7751"
 },
 {
  "_id": "56044569703498dd2a5250b3",
  "cadd": "",
  "cat": "Lifestyle",
  "crat": "Everyone",
  "crt": "Afrika Inspire",
  "curl": "/store/apps/developer?id=Afrika+Inspire",
  "dct": 500000,
  "desc": "We are here to showcase the most relevant fashion styles from Madivas - Africa's largest fashion magazine.  Check out pictures on what to wear for that wedding, birthday party or how to apply the best foundation for that pretty makeup face.  Checkout trending African prints - Asoebi, Ankara, French lace, Vulvet and Corporate styles for events, weddings, burial, naming ceremony or birthdays.   What ever your fashion needs are, we have your back with the latest fashion styles in Nigeria and Africa at large.  Also feel free to use app to send us some of your amazing pictures and get featured on our website with over 500,000  daily page views and our Facebook page with over 600,000 likes.  Some of the interesting segments on the app includes Asoebi Styles Amazing Hair Styles Celebrity Styles Office Corporate Styles Friday Night Styles Sunday Church Styles MakeUp Essentials Amazing Shoes Wedding Digest UPDATES: Faster uploads of pictures for users with slow internet access. More updates on hair styles and makeup trends. Get notifications when the most interesting and trendy pictures currently in vogue is available for your consumption. Share your latest outfit and trendy styles easily with your friends.  Got suggestions? We want to hear them! Send your comments and suggestions to us at:  fashionpolicenigeria@gmail.com",
  "dtp": "September 1, 2015",
  "dtxt": "500,000 - 1,000,000",
  "n": "com.andromo.dev415642.app399075",
  "new": "Faster Upload Of Images. Cleaner User Interface",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.1,
  "rct": 3545,
  "sz": "3.2M",
  "t": "Latest Fashion Styles Africa",
  "verc": "2099",
  "id": "com.andromo.dev415642.app399075-2099"
 },
 {
  "_id": "56044572703498dd2a52598d",
  "cadd": "",
  "cat": "Photography",
  "crat": "Everyone",
  "crt": "Bapu Ki Apps",
  "curl": "/store/apps/developer?id=Bapu+Ki+Apps",
  "dct": 10000,
  "desc": "Most dared people of the world, called Army man, who are going to protect against war and attack. There is android apps which will provide Army dress based on your thinking power. Lot's of dresses available all seems like jental man. Cool android apps to show your photo with Army dress. All country army dress available. \tIndian Army dress. \tAmerican Army dress. \tAustralian Army dress. \tSwitzerland Army dress. it seems like real Army man . Features:     100% free android apps.      You can share over the social network like whatsapp,facebook,twitter etc.      You can save,store and show later to other.  Note: We should salute to Army man, give respect to them. because they gives protection to country and save lots of life during war.",
  "dtp": "September 1, 2015",
  "dtxt": "10,000 - 50,000",
  "n": "com.my.efrt.special.army.allv1",
  "new": "New Features Added",
  "os": "2.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.2,
  "rct": 211,
  "sz": "3.8M",
  "t": "Army Photo Suit",
  "verc": "1870",
  "id": "com.my.efrt.special.army.allv1-1870"
 },
 {
  "_id": "56044572703498dd2a525f7a",
  "cadd": "",
  "cat": "Education",
  "crat": "Everyone",
  "crt": "Orthographe Projet Voltaire",
  "curl": "/store/apps/developer?id=Orthographe+Projet+Voltaire",
  "dct": 100000,
  "desc": "Pour dire adieu aux fautes d'orthographe et de grammaire (conjugaison, accords...), Projet Voltaire vous propose une méthode unique d'entraînement et de remise à niveau - avec des tests et des exercices d'orthographe et de grammaire - qui est la seule à s'adapter automatiquement à vos lacunes et à votre rythme d'

There are 3202 apps