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

There are 40 apps.

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

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

[
 {
  "_id": "56044572703498dd2a525db3",
  "cadd": "UNIT04， 7/F, BRIGHT WAY TOWER, NO.33 MONG KOK ROAD , KOWLOON , HK",
  "cat": "Health & Fitness",
  "crat": "Everyone",
  "crt": "ABISHKKING",
  "curl": "/store/apps/developer?id=ABISHKKING",
  "dct": 50000000,
  "desc": "The ★highest rating (4.7)★ period calendar! Top 1 in Health & Fitness Over 43 Countries. Top 5 in Health & Fitness Over 63 Countries. Over 40,000,000 Android Users love Period Calendar. Every woman loves Period Calendar, How great it is? --------------------------------------------------- Shannon Thibodeax on Jun 15, 2015 at 10:41 AM The best calender!!!! Love it always lets me know everything I need to know, and its never wrong. Rocio Espindola on Jun 13, 2015 at 2:27 AM Love this app With this app i was able to get pregnant. --------------------------------------------------- Period Calendar , The best app to help track your period, cycle ,ovulation and the chance of pregnancy, especially useful for those women wishing to  conceive , or  birth control , contraceptive even have  irregular periods . Also you can connect with other women if you have any questions in the nice  community . Period Calendar is the easy application period tracker for irregular periods and for girls to check the  pregnancy chance every day . It can track cervical mucus, BMI, intercourse, weight, temperature, symptoms or moods, just like your personal diary, help you keep fitness,  lose weight , conceive and keep healthy.  It also discreet remind you when you come period, fertile or ovulation, as well as remind you of taking  contraceptive pills , insert rings, patch or injection. you can be exported the file to doctors. Period Calendar supports  Google account , Dropbox, email or SD card to backup data, you won't lose data ever change phone or lost phone. ★ Community Platform - Connect with other women - To read, reply and post messages about Health, Family, Teenager, and woman life, etc. - To communicate and exchange ideas with each other about any topics ★ Pill Reminder & Period Reminder :  - Customize the notification text to make it discreet, and never worry about feel awkward in public.  - Set notifications date and time according to need - Notification for period, fertility and ovulation tracker - Contraceptive pill reminder (include pill, ring, patch & injection) ★ Trying to get pregnant & Birth Control:  - Fertile symptoms tracker, like cervical firmness, cervical mucus, cervical opening - When get pregnant, help you to track your pregnant date - When finish pregnancy, easily back to period tracker & prediction mode ★ Loss Weight, Tracker Symptoms & Moods : - Weight BMI, and temperature charts - Intimacy tracker - 43 symptoms and 64 moods to choose, include cervical mucus - Body temperature chart for determine ovulation date - Smart predict your ovulation date according to the ovulation test result ★ Period & Fertile Tracker: - Check pregnancy chance every day  - Menstruation, Cycles, Ovulation prediction, help you have everything in plan - Cycle tracker, Period tracker for irregular periods - Period ovulation tracker, cycle tracker, fertile tracker - Ovulation Calendar - Period and ovulation tracker ★ Never Lost Data: - Google Account data backup and Restoration - Backup your period data to phone or email - Restore Period tracker data from SD card and email ★ Multi Account & Security: - Multi accounts for period ovulation tracker - Security protections for period tracker light contraceptive - Customer your personal period length, cycle length and ovulation, for irregular periods - Multi language to choose - View or search all notes through timeline - Forums Period Calendar is very safety, contact us if you have any security question. Permissions description: -Your accounts  For filling email address when setting password or backup data to email; -Network communication For Google account, email, Dropbox, cloud storage data backup & restoration; -System tools This permission is for starting up notification & widgets even reboot the phone; -Hardware controls For notification vibration; -Storage  For writing data to SD card & reading data from SD card;",
  "dtp": "September 17, 2015",
  "dtxt": "50,000,000 - 100,000,000",
  "n": "com.popularapp.periodcalendar",
  "new": "V1.553 ● Improved reminder, easy to check and track ● The widget not show negative value when period is late ● Fixed the issue of slow or not respond on some special models ● Online bug fixed V1.552 ● Fixed the black or white screen issue on some special models ● Online crash fixed V1.551 ● Improved the settings, easy to find and adjust the cycle length if you feel not accurate ● Widget shows negative when period is late ● Fixed the reminder issue that system date is wrong when restart phone",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "",
  "rate": 4.7,
  "rct": 2152297,
  "sz": "Varies with device",
  "t": "myCalendar - Period Tracker",
  "verc": "9559",
  "id": "com.popular

There are 33 apps.

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.

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": "56044571703498dd2a52528f",
  "cadd": "",
  "cat": "Business",
  "crat": "Unrated",
  "crt": "SwebDevelopment",
  "curl": "/store/apps/developer?id=SwebDevelopment",
  "dct": 10,
  "desc": "Official Leader-led Movements App for CCCI",
  "dtp": "December 12, 2011",
  "dtxt": "10 - 50",
  "n": "com.leaderled",
  "new": "",
  "os": "2.2 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4,
  "rct": 1,
  "sz": "717k",
  "t": "Leader-led Movements",
  "verc": "9358",
  "id": "com.leaderled-9358"
 },
 {
  "_id": "56044571703498dd2a52528c",
  "cadd": "",
  "cat": "Business",
  "crat": "Everyone",
  "crt": "Leaders Merchant Services, LLC",
  "curl": "/store/apps/developer?id=Leaders+Merchant+Services,+LLC",
  "dct": 1000,
  "desc": "Rates as low as 0.35%! That is less than a half of a percent! LEADERS has an A+ BBB Rating! Leaders is an ISO/MSP of Wells Fargo Bank, NA. Swiped rate programs now available! CALL 800-506-8850 to Apply Now. Our credit card processing application makes it easier than ever to start accepting credit cards using your Android. With our full featured application, your Android is turned into a virtual terminal, allowing you to process credit cards just about anywhere! LEADERS offers the most competitive Rates and Fees. We can customize a plan to fit your needs. LEADERS will meet or beat any competitor’s written offer! With a new LEADERS Merchant Services Account and this Application, there are: »Swiped Rates as low as $0.35%  »FREE Audio Card Reader (works with Android touch) »FREE Set up »FREE Monthly Gateway Service  »NO Statement Fee »High Approval Rate »Superior Customer Service Why buy a credit card terminal that keeps you tied to a land line, or a very expensive mobile terminal when you can download this free application that turns your Android touch into a wireless credit card machine? Why open just an online merchant account when you can process your credit card transactions right in the palm of your hand using your Android touch? Our Credit Card Processing Application is packed with more features than any other similar Android  application available today. Our features include:  »Process Visa transactions »Process MasterCard transactions »Process Discover transactions »Process American Express (AMEX) transactions »Even process JCB and Diners Club transactions »Accept payments from Charge cards and Debit cards »Run authorization only (holds) that can be completed later using the Capture function »Issue Credits or Refunds »Void incorrect transactions (errors) »Enter and store customer contact information, order information, shipping information and associate it with the transactions you run. »Email receipts directly to your customers »Add Tip function (% or $ amount) »Recurring Billing feature (Auth.net optional fee based service)  »On screen access to user friendly help files Ask us about our entire suite of services which includes Merchant Cash Advances, Check Services including Check Guarantee and Electronic Check Conversion (ECC) as well as Check 21 and Gift Card programs.  If your business does not accept Credit Cards you are probably losing business to a competitor. Setting up your business to take Credit Cards can be the quickest way to grow your business. People that use credit cards generally spend more per transaction than those using cash or checks. Getting started is easy! Download this FREE Application TODAY. Then either call us at the toll free number below or contained in the app, or press the “set up a Merchant Account” button in the app and then press the “request to be contacted” button and provide us some brief information about you and one of our Account Executives will contact you! LEADERS is one of the most trusted names in the Merchant Services Industry. Don’t settle for just any Credit Card Processor, go with the Best! Contact us: iPhone@LeadersMerchantServices.com  Phone: 1 -800 – 506 – 8850 USA based merchants ONLY LANGUAGES: English REQUIREMENTS: Compatible with Android touch",
  "dtp": "March 24, 2015",
  "dtxt": "1,000 - 5,000",
  "n": "com.leader.merchant",
  "new": "",
  "os": "2.2 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.7,
  "rct": 26,
  "sz": "1.2M",
  "t": "Credit Card Merchant Account",
  "verc": "1065",
  "id": "com.leader.merchant-1065"
 },
 {
  "_id": "56044571703498dd2a5252a5",
  "cadd": "LEAPFACTOR INC",
  "cat": "Business",
  "crat": "Everyone",
  "crt": "LEAPFACTOR INC",
  "curl": "/store/apps/developer?id=LEAPFACTOR+INC",
  "dct": 1000,
  "desc": "This application is for Rena Ware Consultants only. Our interactive app provides you with the latest technology to support your business. RenaApp will support you with interactive training; dynamic catalog browsing & list creation; product, training & sponsoring videos, call scripts and other documents to support selling and sponsoring plus, announcements and much more. Present a professional image of your business, save time and work more efficiently with information and trai

There are 3179 apps.

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

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

[]

There are 0 apps.

Hint: The query matches one app in the dataset and the link to its Google Play listing page is: https://play.google.com/store/apps/details?id= Read the reviews to find out why?

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

{"$and": [ {"rate": {"$gt": 4 }}, {"dct": {"$gt": 10000000}} ]}

[
 {
  "_id": "56044572703498dd2a525db3",
  "cadd": "UNIT04， 7/F, BRIGHT WAY TOWER, NO.33 MONG KOK ROAD , KOWLOON , HK",
  "cat": "Health & Fitness",
  "crat": "Everyone",
  "crt": "ABISHKKING",
  "curl": "/store/apps/developer?id=ABISHKKING",
  "dct": 50000000,
  "desc": "The ★highest rating (4.7)★ period calendar! Top 1 in Health & Fitness Over 43 Countries. Top 5 in Health & Fitness Over 63 Countries. Over 40,000,000 Android Users love Period Calendar. Every woman loves Period Calendar, How great it is? --------------------------------------------------- Shannon Thibodeax on Jun 15, 2015 at 10:41 AM The best calender!!!! Love it always lets me know everything I need to know, and its never wrong. Rocio Espindola on Jun 13, 2015 at 2:27 AM Love this app With this app i was able to get pregnant. --------------------------------------------------- Period Calendar , The best app to help track your period, cycle ,ovulation and the chance of pregnancy, especially useful for those women wishing to  conceive , or  birth control , contraceptive even have  irregular periods . Also you can connect with other women if you have any questions in the nice  community . Period Calendar is the easy application period tracker for irregular periods and for girls to check the  pregnancy chance every day . It can track cervical mucus, BMI, intercourse, weight, temperature, symptoms or moods, just like your personal diary, help you keep fitness,  lose weight , conceive and keep healthy.  It also discreet remind you when you come period, fertile or ovulation, as well as remind you of taking  contraceptive pills , insert rings, patch or injection. you can be exported the file to doctors. Period Calendar supports  Google account , Dropbox, email or SD card to backup data, you won't lose data ever change phone or lost phone. ★ Community Platform - Connect with other women - To read, reply and post messages about Health, Family, Teenager, and woman life, etc. - To communicate and exchange ideas with each other about any topics ★ Pill Reminder & Period Reminder :  - Customize the notification text to make it discreet, and never worry about feel awkward in public.  - Set notifications date and time according to need - Notification for period, fertility and ovulation tracker - Contraceptive pill reminder (include pill, ring, patch & injection) ★ Trying to get pregnant & Birth Control:  - Fertile symptoms tracker, like cervical firmness, cervical mucus, cervical opening - When get pregnant, help you to track your pregnant date - When finish pregnancy, easily back to period tracker & prediction mode ★ Loss Weight, Tracker Symptoms & Moods : - Weight BMI, and temperature charts - Intimacy tracker - 43 symptoms and 64 moods to choose, include cervical mucus - Body temperature chart for determine ovulation date - Smart predict your ovulation date according to the ovulation test result ★ Period & Fertile Tracker: - Check pregnancy chance every day  - Menstruation, Cycles, Ovulation prediction, help you have everything in plan - Cycle tracker, Period tracker for irregular periods - Period ovulation tracker, cycle tracker, fertile tracker - Ovulation Calendar - Period and ovulation tracker ★ Never Lost Data: - Google Account data backup and Restoration - Backup your period data to phone or email - Restore Period tracker data from SD card and email ★ Multi Account & Security: - Multi accounts for period ovulation tracker - Security protections for period tracker light contraceptive - Customer your personal period length, cycle length and ovulation, for irregular periods - Multi language to choose - View or search all notes through timeline - Forums Period Calendar is very safety, contact us if you have any security question. Permissions description: -Your accounts  For filling email address when setting password or backup data to email; -Network communication For Google account, email, Dropbox, cloud storage data backup & restoration; -System tools This permission is for starting up notification & widgets even reboot the phone; -Hardware controls For notification vibration; -Storage  For writing data to SD card & reading data from SD card;",
  "dtp": "September 17, 2015",
  "dtxt": "50,000,000 - 100,000,000",
  "n": "com.popularapp.periodcalendar",
  "new": "V1.553 ● Improved reminder, easy to check and track ● The widget not show negative value when period is late ● Fixed the issue of slow or not respond on some special models ● Online bug fixed V1.552 ● Fixed the black or white screen issue on some special models ● Online crash fixed V1.551 ● Improved the settings, easy to find and adjust the cycle length if you feel not accurate ● Widget shows negative when period is late ● Fixed the reminder issue that system date is wrong when restart phone",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "",
  "rate": 4.7,
  "rct": 2152297,
  "sz": "Varies with device",
  "t": "myCalendar - Period Tracker",
  "verc": "9559",
  "id": "com.popular

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": {"$nin": [
"Card", "Entertainment", "Comics", "Puzzle"]}}   
         ] }

[
 {
  "_id": "56044569703498dd2a525111",
  "cadd": "9450 SW Gemini Dr #60274\nBeaverton, OR 97008-7105",
  "cat": "Sports",
  "crat": "Teen",
  "crt": "Conjugo LLC",
  "curl": "/store/apps/developer?id=Conjugo+LLC",
  "dct": 10000,
  "desc": "Get the latest Atlanta Braves news, videos, photos, social media updates, podcasts, matchup tool, scores, team store and chat with Braves fans in this all in one unofficial FREE fan app!",
  "dtp": "May 23, 2015",
  "dtxt": "10,000 - 50,000",
  "n": "com.andromo.dev86290.app221279",
  "new": "- Bug fixes - Fan bars map - Other apps",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.conjugo.com/privacy.php&sa=D&usg=AFQjCNGT5MyF9MV19LHSVyd8JETMWq3yew",
  "rate": 4.1,
  "rct": 75,
  "sz": "4.3M",
  "t": "Atlanta Baseball",
  "verc": "1843",
  "id": "com.andromo.dev86290.app221279-1843"
 },
 {
  "_id": "56044569703498dd2a525145",
  "cadd": "",
  "cat": "Lifestyle",
  "crat": "Teen",
  "crt": "AnDworks",
  "curl": "/store/apps/developer?id=AnDworks",
  "dct": 1000,
  "desc": "문자메시지에 ‘주석’을 허하라! 약속장소 하나 정하는데 톡톡하다, 검색갔다, 정보앱갔다, 지도갔다, 불편하지 않으셨나요? 이제 메신저 하나만 열어 필요한 관련정보, 그 자리에서 검색하거나 뚝딱 만들어서  단어에 하이퍼텍스트로 달아 똑똑하게 보냅시다. SMS, MMS를 넘어,  하이퍼노트 메신저- HMS  * 뉴스, 블로그, 사전 등 포탈정보 검색해 넣기  * 직접 모바일 웹페이지를 만드는 콘텐츠 편집기   * PC에 있는 정보를 가져오는 클립보드서비스  * 인터넷검색을 위한 인앱브라우저   * 내게 필요한 주석을 보관하는 내링크함  * 만든 정보를 공개하면 모바일 블로거   * 검색엔진에 나타나지 않는 어플 안 콘텐츠 검색 툴  * 외부 메신저로 내보내기  * 검색광고를 위한 모바일 오버추어",
  "dtp": "July 9, 2015",
  "dtxt": "1,000 - 5,000",
  "n": "com.andworks.hms",
  "new": "Version. 1.1.0 [수정 사항] * 기기별 최적화 및 버그 수정",
  "os": "2.3.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.6,
  "rct": 24,
  "sz": "7.0M",
  "t": "HMS - 검색, 정보, 대화를 한번에!  통합메신저",
  "verc": "7635",
  "id": "com.andworks.hms-7635"
 },
 {
  "_id": "56044569703498dd2a52517c",
  "cadd": "",
  "cat": "Simulation",
  "crat": "Teen",
  "crt": "BroadcastFarer",
  "curl": "/store/apps/developer?id=BroadcastFarer",
  "dct": 10000,
  "desc": "elephant simulator mania This is a fun simulator! Destroys everything A Giant Elephant rampaging in the city. Explore a 3D city with a giant elephant hitting and exploding. These Elepahnts are super strong and love to create chaos. Smash cars, tractors, goats, planes, fire hydrants, people, men,women,wheels, quad bikes, and anything else not attached to the ground.  This is a fun simulator! Destroys everything!  Top Game Features: ** Hunt down animals to collect meat units ** Rabbits, Ducks, Bats, Deer, Wild Dogs, Horses, Eagles, Crocodiles, and Wolf. ** 3 Different Times of Day, including rain ** Massive Open World 3D Map ** Upgrade your Puma Speed, Strength, and Stamina. Survive against the elements for as long as you can in the high action wild animal simulator. The secret to the game is survival. There are 2 goals. First, you must rescue all your family members. Second, you must try and defeat all 4 of the giant bosses. In the meantime, you must hunt down your next meal to earn meat points for animal upgrades. When you face off with a giant boss, don't forget to call on your family members for assistance by using the call button. The faster you go and the more destruction you cause the higher you score!",
  "dtp": "June 27, 2015",
  "dtxt": "10,000 - 50,000",
  "n": "com.animalsimulator.mania.Elephant",
  "new": "",
  "os": "2.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 3.1,
  "rct": 212,
  "sz": "35M",
  "t": "Elephant Simulator Mania",
  "verc": "8016",
  "id": "com.animalsimulator.mania.Elephant-8016"
 },
 {
  "_id": "56044569703498dd2a52517d",
  "cadd": "",
  "cat": "Simulation",
  "crat": "Teen",
  "crt": "BroadcastFarer",
  "curl": "/store/apps/developer?id=BroadcastFarer",
  "dct": 50000,
  "desc": "sabertooth tiger RPG Use your razor sharp claws and massive teeth to hunt down Always wanted to be a predator? Start as a newbie saber-tooth tiger and evolve to a real terror of the wild! At first you will be able to hunt only weak animals like rams and sheep. But after you evolve you will be able to hunt down tigers, panthers and huge spiders! Explore a huge custom-built terrain!  Every time you play the game it will be a different experience. The animals, weather, and time of day is constantly changing. When you hunt, you will earn meat units. These meat units can be used to purchase upgrades for your Crocodile. A special feature in the app allows you to keep a record of your hunting success. Challenge your fighting skills against 6 different 3 on 1 battles. Be prepared for a flight for survival. You either win or loose. Introducing unlimited missions and over two dozen achievements to give you a boost of experience! With the level cap increased to 200, you’ll need all the help you can get! Ready to put your sabertooth to the test? Enter into combat with 4 deadly bosses that will push you to your limits! Succeed in slaying them and your rewards will be plentiful!",
  "dtp": "July 11, 2015",
  "dtxt": "50,000 - 100,000",
  "n": "com.animalsi

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": "56044593703498dd2a528819",
  "cadd": "",
  "cat": "Shopping",
  "crat": "Teen",
  "crt": "eBay Mobile",
  "curl": "/store/apps/dev?id=6005619443614255030",
  "dct": 100000000,
  "desc": "The eBay app is packed full of features that make it easy to browse, buy, sell and manage your eBay experience whenever and wherever you are! With eBay mobile you can: ✓ Search, Bid, Buy or Make offers on unique items from sellers worldwide ✓ List your items for sale on eBay in minutes ✓ Use the barcode scanner to find items, compare prices or start a new listing ✓ Get customizable alerts about your eBay items and activity ✓ Track your packages ✓ Leave feedback ✓ Read and respond to eBay messages ✓ Follow your favorite searches and sellers for quick access to the latest inventory ✓ Revise your listings and manage your eBay business on the go ✓ So much more. We’ll stop here so you can start shopping now _____________________________________ LANGUAGE SUPPORT English, French, Italian, German, Spanish, Portuguese, Russian, Polish, Dutch (Belgium and Netherlands) _____________________________________ KEEP IN TOUCH Thanks to all our loyal fans for your support and suggestions!  Your feedback is important to us. Please contact us with any questions by tweeting @askebay or join the discussion at www.ebay.com/android _____________________________________ PERMISSIONS We know it can be a little scary to see applications requesting permission to access areas of your device functionality, so we're trying to be as transparent as possible. Here are some answers to common questions about what we do with these permissions: YOUR ACCOUNTS: We need access to the account associated with your device so that we can send you push notifications.  SYSTEM TOOLS: This allows us to wake up the device in order to send you notifications. The device will return to sleep mode automatically. LOCATION: We surface more relevant search results to you based on your location.  NETWORK COMMUNICATION: Share items with friends or good looking strangers using NFC. Just enable NFC in your device settings, then hold your phone up to someone else's and \"Beam\" your item to them!  CAMERA: Allows you to scan barcodes for comparison shopping or to start a new listing, to take photos of an item you're listing, and to attach photos to an eBay message.",
  "dtp": "September 10, 2015",
  "dtxt": "100,000,000 - 500,000,000",
  "n": "com.ebay.mobile",
  "new": "eBay 4.0 for Android is designed to simplify buying and selling, and place the best of eBay front and center. We’ve redesigned navigation, bidding and search, and built a brand new home screen with three personalized channels: •\tActivity: Quick access and timely updates to the things that matter to you •\tShop: Browse a blend of curated and personalized items by department •\tSell: Tools and tips to start listing in minutes or manage your listings on the go",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://ebay.to/1ur6UQ4&sa=D&usg=AFQjCNH5FTyPcp8f6rOl2U_869Ge-akEuQ",
  "rate": 4.2,
  "rct": 1479432,
  "sz": "Varies with device",
  "t": "eBay",
  "verc": "1074",
  "id": "com.ebay.mobile-1074"
 },
 {
  "_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 inform

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

[
 {
  "_id": "5604459c703498dd2a52988c",
  "cadd": "500 Howard St. Suite 300\nSan Francisco CA 94105",
  "cat": "Action",
  "crat": "Unrated",
  "crt": "Glu",
  "curl": "/store/apps/dev?id=8633921029894576093",
  "dct": 5000000,
  "desc": "Welcome to Blood & Glory Legend – the highly anticipated sequel to the AAA blockbuster smash-hit Blood & Glory! Return to the arena and bask in the blood-hungry cheers of the crowd as you fight to become a LEGEND! “Blood & Glory: Legend still manages to be one of the premier fighting games on smartphones and tablets, with a plot thrown in for good measure.” – Game Trailers “Fans of the first game should not be surprised to learn that this one looks amazing.” – Gamezeebo “Visually, Blood & Glory: Legend offers distinct improvements over its forerunner, with detailed environments, impressive combatants, and neat effects such as the blood patches that appear on the fighters as they receive damage.” – PocketGamer “Graphics and sounds are bloody beautiful, making the most of nearly every device known. Overall, it’s a great game that makes mobile gaming greater.” – Android Zoom “The developers have really stepped up in the graphics department.” – Android Police “Much-needed personality normally reserved for premium titles.” – MoDojo The top-rated gladiator combat game continues with Blood and Glory: Legend! Equip lethal weapons and epic armor in your quest to achieve blood-soaked victory over the Emperor himself! MOTION COMIC STORYLINE Journey through the Empire, leaving blood-thirsty bosses in your wake as the all new animated comic story unfolds! STUNNING & AWARD-WINNING AAA GRAPHICS Experience bleeding-edge graphics so realistic that you will duck to avoid the splatter of blood! NEW MOVES & STRATEGY Perfect your skills and unleash stunning Special Attacks, Super Combos and the all new Glorious Strike! Enemies can now perform unblockable and undodgeable attacks so choose your defenses wisely! DAILY BONUS! Come back every day to earn free money and equipment! Complete battles ever day to earn even larger Bonus rewards! NEW ARENAS AND ENEMIES Battle new towering Giants and seductive Claw Vixens to the death in the new Snake Den, Viking Ship, and Neptune Temple! Blood & Glory: Legend is free to play, but you can choose to pay real money for some extra items. Use of this application is governed by Glu Mobile’s Terms of Use. Collection and use of personal data are subject to Glu Mobile’s Privacy Policy. Both policies are available at www.glu.com. Additional terms may also apply. FOLLOW US at Twitter @glumobile facebook.com/glumobile",
  "dtp": "July 18, 2013",
  "dtxt": "5,000,000 - 10,000,000",
  "n": "com.glu.gladiator2",
  "new": "➤ Win FREE Equipment and Demonstrate your battle prowess in 10 All New Challenge Battles (the brown banners on the Map Screen)! ➤ Bug fixes and other improvements to game performance.",
  "os": "2.1 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.glu.com/privacy&sa=D&usg=AFQjCNF7XANVJOJ3yOzV7ujS46miEuS0Xg",
  "rate": 4.6,
  "rct": 403933,
  "sz": "320M",
  "t": "BLOOD & GLORY: LEGEND",
  "verc": "962",
  "id": "com.glu.gladiator2-962"
 },
 {
  "_id": "5604459c703498dd2a529890",
  "cadd": "500 Howard St. Suite 300\nSan Francisco CA 94105",
  "cat": "Action",
  "crat": "Unrated",
  "crt": "Glu",
  "curl": "/store/apps/dev?id=8633921029894576093",
  "dct": 5000000,
  "desc": "The battle for Northern Udar rages on! It's been 100 years since the First Demon War tore the land apart. Thanks to the Eternity Warriors the demon threat was held at bay. However the demons have been consolidating their power in a series of Demon Towers built in locations throughout Northern Udar.  You've been tasked with cleansing these Demon Towers and defeating an even deadlier demon army than before …  REAL TIME PVP AND CO-OP MULTIPLAYER!  Battle against or alongside fellow warriors in ONLINE MULTIPLAYER MODES!  THE ULTIMATE DUNGEON CRAWLING ACTION GAME HITS YOUR ANDROID PHONE AND TABLET! • STUNNING HIGH DEFINITION visuals and EPIC MELEE gameplay!  • Fluid REAL-TIME COMBAT against dozens of NEW demon enemies!  • ONLINE CO-OP MULTIPLAYER! Battle with a fellow warrior in the ONLINE MULTIPLAYER MODE!  • Use your SPECIAL SKILLS to slice your way through MULTIPLE UNIQUE DUNGEONS! • COLLECT ARMOR, WEAPONS and other LOOT! Upgrade your gear to become the ultimate Eternity Warrior in Udar! Eternity Warriors 2 is free to play, but you can choose to pay real money for some extra items. Use of this application is governed by Glu Mobile’s Terms of Use. Collection and use of personal data are subject to Glu Mobile’s Privacy Policy. Both policies are available at www.glu.com. Additional terms may also apply. FOLLOW US at Twitter @glumobile facebook.com/glumobile",
  "dtp": "July 1, 2014",
  "dtxt": "5,000,000 - 10,000,000",
  "n": "com.glu.ewarriors2",
  "new": "► Bug fixes and other improvements to game performance",
  "os": "2.1 and up",
  "pri": "Free",
  "pur

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

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

[
 {
  "_id": "56044572703498dd2a52576e",
  "cadd": "",
  "cat": "Photography",
  "crat": "Everyone",
  "crt": "FunMedia Studio",
  "curl": "/store/apps/developer?id=FunMedia+Studio",
  "dct": 5000000,
  "desc": "KlipMix is a great video maker，It is  so easy use，In one minute，you can mix videos and photos together，add your favorite music，share with friends. Best of all，it is all free，and no watermark. Features: - Mix video and photo  together - Add video and photos quickly and easily - Easy gestures, unselect and reorder photos with touch and drag. - Add your favorite music  - Trim video - Modify display duration of each video and photo - Share videos with friends Any suggestion or problem you can send email to  xfunstudio@gmail.com Hope you enjoy this app！",
  "dtp": "August 8, 2015",
  "dtxt": "5,000,000 - 10,000,000",
  "n": "com.movisoft.klips",
  "new": "V2.7 1. Fix some bugs. 2. Optimize video exporting performance. V2.6 1. Improve slideshow making experience 2. Fix some bugs",
  "os": "2.3 and up",
  "pri": "Free",
  "purl": "",
  "rate": 4.1,
  "rct": 120283,
  "sz": "5.3M",
  "t": "KlipMix - Free Video Maker",
  "verc": "5928",
  "id": "com.movisoft.klips-5928"
 },
 {
  "_id": "56044572703498dd2a525930",
  "cadd": "",
  "cat": "Lifestyle",
  "crat": "Everyone",
  "crt": "PXL APPS",
  "curl": "/store/apps/developer?id=PXL+APPS",
  "dct": 5000000,
  "desc": "*** Prayer times and Qibla: Accurate and Free *** « Prayer times ® Muslim Toolbox » is an Android app for the Muslims all around the world. This app provides islamic prayer times (Salat) and the direction to the Qibla wherever you are in the world. --> Accurate and exact Salat: - Shows the times for the Fajr, Sunrise, Dhuhr, Asr, Maghrib et Isha. --> A quick and easy selection of the city: - Select your city manually amongst a list of 6 000 000 in 251 countries, or be located automatically thanks to your integrated GPS. - Memorize your favorite cities. --> Configurable Calculation of the timetable: - Several methods of calculation (for Fajr and Isha). - Various juristic methods (for the Asr). - Adjust manually the twilight angle (for the Fajr and Isha). - Adjust manually the minutes for each. - Display the hours with the AM/PM format. --> Adhan notifications: - Activate the notifications in order to be informed when it is time, so that you won’t miss any prayer. - Select the azan for which you want to be warned. - Wake up to the sound of the alarm before the Fajr. --> Direction of Mecca / Qibla : - Use the compass to know in which direction to pray. - Indication about the distance between your position and the position of the Mecca. --> Rakats counter. --> The others features: - A pretty neat GUI with a little touch of Islamic art.  - A help/support menu in case of a technical problem. - New features coming as the application is in constant evolution. For any questions, suggestions or bug report: a tutorial, a F.A.Q and a contact form are available on the application. The team of « Prayer times ® Muslim Toolbox » is aware of the importance of Salat in Islam. We provide you an useful Android application that will keep you informed about the exact hours of Salat throughout the year. Download and recommend this program to your friends and family. - Follow us on:  http://www.facebook.com/muslimtoolbox   http://www.twitter.com/muslimtoolbox https://plus.google.com/u/0/117058153069181744965/posts    Thank you in advance for your comments. May Allah preserve us and guide us all to the right path.",
  "dtp": "May 23, 2015",
  "dtxt": "5,000,000 - 10,000,000",
  "n": "com.muslimtoolbox.app.android.prayertimes",
  "new": "- Bug fix",
  "os": "Varies with device",
  "pri": "Free",
  "purl": "",
  "rate": 4.4,
  "rct": 56325,
  "sz": "Varies with device",
  "t": "Prayer times: Qibla & Azan",
  "verc": "7693",
  "id": "com.muslimtoolbox.app.android.prayertimes-7693"
 },
 {
  "_id": "56044572703498dd2a525968",
  "cadd": "G1, 07, Sri Ranganatha Arcade, Bhuvaneswari Road,\nNext to Sri karu mari amma road, Whitefield, Bangalore, India - Pin: 560066",
  "cat": "Casino",
  "crat": "Teen",
  "crt": "Mywavia Studios",
  "curl": "/store/apps/dev?id=8815230470063088971",
  "dct": 5000000,
  "desc": "Virtually Experience Live Casino with Classic Slots Royale - Slot Machines and Bonus games.  ABSOLUTELY FREE. NO PURCHASES AND NO REAL MONEY INVOLVED. Game Features :   •  6 Paying Machines - Play three of them at the same time and experience Vegas. Just a swipe away to switch slots and win endlessly.   •  The lovable bonus games - Jacks or Better Video Poker & Offline Wheel of Fortune simulator.   •  Live challenges with millions of players in tournaments.   •  Multi Paylines - Bet Heavy playing 5 Paylines in pokies.   •  Shop, to buy virtual items for yourself and your friends. Send, and Accept Gifts from your friends and loved ones in slots machine.   •  Leader Board to view World wide and country wise rankings for virtual money and items. Hall of Fame lists players' pic

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

Hint: You can use the $regex operator

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

[
 {
  "_id": "56044572703498dd2a5254d7",
  "cadd": "",
  "cat": "Shopping",
  "crat": "Everyone",
  "crt": "Listia",
  "curl": "/store/apps/developer?id=Listia",
  "dct": 1000000,
  "desc": "Check out millions of FREE items other people are giving away nearby! Over 100 Million items have been traded for free on Listia! Listia is a mobile garage sale and yard sale marketplace like craigslist where you sell things you don't need and get stuff you want in return, for FREE. Earn credits by selling stuff for others to reuse, and use those credits to get stuff you really want, like Jewelry, Electronics, Clothing, Gadgets, Books, Toys, Gift Cards, Games and Coins. The more you give and sell, the more free things you can buy without spending money. How It Works: 1) Declutter - Sell all the things you don't use - from DVDs to Cell Phones, for free, like a mobile craigslist, yard sale or garage sale! 2) Earn Credits - Rack up credits when others buy your listings. 3) Reward Yourself - Discover and get stuff you'll love from other members or the Listia Rewards Store! The mobile app makes listing auctions to sell a snap. Simply take a photo with your device, add some details, and post it to Listia instantly. The Listia app will show you what nearby users are trading, selling & giving away, let you buy and bid on things you want, and notify you when you're outbid or an item you're watching is ending. Next time you feel like listing things in the free section of craigslist or sell at a local garage or yard sale, give Listia a try and see all the cool things you can get!",
  "dtp": "September 1, 2015",
  "dtxt": "1,000,000 - 5,000,000",
  "n": "com.listia.Listia",
  "new": "* Improvements to credit buying * Bug fixes Please use in-app support if you encounter any problems. Give us a five-star review if you like the app. Enjoy! Listia updates our app regularly to give you the latest features. You can keep your app updated automatically by enabling the \"Auto-update apps\" setting in Google Play.",
  "os": "4.0 and up",
  "pri": "Free",
  "purl": "https://www.google.com/url?q=http://www.listia.com/privacy&sa=D&usg=AFQjCNHQhm47L147Pf6QR0Jj9mVZocrSUw",
  "rate": 4.2,
  "rct": 25269,
  "sz": "6.2M",
  "t": "Listia - Get Free Stuff & Sell",
  "verc": "8865",
  "id": "com.listia.Listia-8865"
 },
 {
  "_id": "56044572703498dd2a525682",
  "cadd": "",
  "cat": "News & Magazines",
  "crat": "Everyone",
  "crt": "Ei DEVELOPER",
  "curl": "/store/apps/developer?id=Ei+DEVELOPER",
  "dct": 10000,
  "desc": "Dapatkan informasi seputar Lowongan Kerja secara cepat dan update, Lowongan Kerja Update ini memuat informasi lowongan pekerjaan dari beberapa sumber terpercaya dan populer seperti : JobsCDC Bursa Kerja Depnakertrans Career Builder ECC UGM Kedai Karir Klik Karir Dunia Karir Karir com Career Jet Loker Web Id JakJobs JobIndo Indoloker 123 Bursa Lowongan Kerja Jobs ID lowongan kerja bontang Aplikasi Informasi Lowongan Kerja Update memberikan anda informasi update tentang lowongan kerja yang tersedia. Lowongan Kerja diupdate setiap hari, berasal dari sumber-sumber terpercaya. Tersedia lowongan kerja dari berbagai disiplin Ilmu, berbagai perusahaan, baik perusahaan besar maupun kecil. Serta informasi lengkap lowongan kerja dari berbagai daerah. Dengan menggunakan aplikasi Lowongan Kerja Update ini Anda tidak perlu lagi membuka dan membaca banyak situs/website untuk mencari info lowongan pekerjaan terbaru. Fitu-fitur aplikasi Lowongan Kerja Update : 1. Update Informasi Lowongan Kerja yang Update secara realtime dari berbagai sumber dan situs populer  2. Notifikasi artikel baru setiap 4 jam (dapat di setting sesuai keinginan pengguna) 3. Membaca artikel secara offline setelah mendownload berita. 4. dapat mensetting berita lowongan yang ingin ditampilkan melalui explorer Aplikasi ini hanya merupakan alat pencarian dan menampilkan informasi lowongan kerja terbaru saja, kami tidak terlibat dalam semua proses yang berhubungan dengan perekrutan. Jika ada hal-hal yang ingin ditanyakan berkaitan dengan lowongan pekerjaan yang ada, Anda bisa menghubungi perusahaan yang menyediakan lowongan tersebut. Aplikasi ini secara default akan mensinkronisasi berita terbaru dari situs rujukan setiap 4 jam sekali, anda dapat mengatur settingan waktu dengan memilih setting - sync interval, atau mematikan fungsi ini dengan menghilangkan check pada Automatic background sync Silahkan berikan review untuk pengembangan aplikasi ini selanjutnya Mohon diperhatikan bahwa Lowongan Kerja Update tidak memungut biaya apapun kepada pencari kerja sebagai persyaratan untuk dapat diterima bekerja. Apabila terjadi perusahaan meminta anda untuk mengirimkan sejumlah uang untuk berbagai alasan. Lowongan Kerja Update menyatakan bahwa kami tidak bertanggung jawab atas kerugian yang diderita. Terima kasih.  Daerah Lowongan kerja : Aceh Bali Bangka Belitung Banten Bengkulu DKI Jakarta Gorontalo Jakarta Barat Jakarta Pusat Jakarta Raya Jakarta Selatan Jakarta Timur Jakarta Utara Jambi 

There are 3202 apps