MongoDB
Write MongoDB queries in a real editor, run them against a seeded dataset, and submit to have the result checked.
0 / 50 solved0%
Easy 0/13Medium 0/27Hard 0/10
Difficulty
Category
Status
- 1Find active usersFundamentalsEasy
- 2Find the admin accountFundamentalsEasy
- 3Find users from BangaloreFundamentalsEasy
- 4Find users older than 25FundamentalsEasy
- 5Find active members over 25FundamentalsEasy
- 6Return only selected fieldsFundamentalsEasy
- 7Sort users by ageFundamentalsEasy
- 8Cheapest in-stock productsFundamentalsEasy
- 9Find active sellersQueryingEasy
- 10Find expensive productsQueryingEasy
- 11Find products in a price rangeQueryingEasy
- 12Find staff in selected rolesQueryingEasy
- 13Find delivered high-value ordersQueryingEasy
- 14Find delivered or high-value ordersQueryingMedium
- 15Exclude cancelled and pending ordersQueryingMedium
- 16Find users with a pincode on fileQueryingMedium
- 17Find products whose name contains keyboardQueryingMedium
- 18Find users by nested address cityQueryingMedium
- 19Find users interested in techArraysMedium
- 20Find users with two required interestsArraysMedium
- 21Find products with required tagsArraysMedium
- 22Find orders with a matching line itemArraysMedium
- 23Find orders with exactly three line itemsArraysMedium
- 24Preview a restock of 10 unitsUpdatesMedium
- 25Drop internal fields from a catalogue payloadUpdatesMedium
- 26Filter delivered orders in a pipelineAggregationMedium
- 27Reshape orders into a summaryAggregationMedium
- 28Add the order year as a computed fieldAggregationMedium
- 29Count users by cityAggregationMedium
- 30Average salary by departmentAggregationMedium
- 31Orders grouped by statusAggregationMedium
- 32Total spending by customerAggregationMedium
- 33Average order value by payment methodAggregationMedium
- 34Find customers with more than 3 ordersAggregationMedium
- 35Find the highest-spending customerAggregationMedium
- 36Top 5 products by priceAggregationMedium
- 37Flatten order line itemsAggregationMedium
- 38Join users and orders using $lookupAdvanced AggregationMedium
- 39Customers who have never placed an orderAdvanced AggregationMedium
- 40Top 3 customers by spendingAdvanced AggregationHard
- 41Monthly revenueAdvanced AggregationHard
- 42Most frequently purchased productsAdvanced AggregationHard
- 43Average review rating by productAdvanced AggregationHard
- 44Label in-stock products as low or okAdvanced AggregationMedium
- 45Build a product sales and reviews reportReal WorldHard
- 46Build a customer analytics snapshotReal WorldHard
- 47Monthly sales by categoryReal WorldHard
- 48Find customers with no recent ordersReal WorldHard
- 49Build a category performance reportReal WorldHard
- 50Build a delivered-order customer lifetime viewReal WorldHard
Showing 50 of 50 problems.