MongoDB query examples

67 worked examples. Each one is a plain-English question compiled into a real query, then executed to confirm it runs.

• find customers with no email on file
• find products with no category set
• list all the different order statuses in use
• find pending orders over $50
• find in-stock products under $30
• find active customers created in the last 60 days
• count how many products are in each order on average
• find orders that include a specific product
• list all orders with their product names attached
• list all orders with their customer name attached
• sort products alphabetically by name
• find the oldest orders
• find the newest customers
• how many products are in the catalog
• show the number of distinct customers who ordered each product
• find the most popular product category by number of orders
• show total revenue broken down by customer status
• calculate the average number of products per order
• find products that appear in more than 5 different orders
• for each customer show their first order date and most recent order date
• find customers whose average order value is above $100
• calculate what percentage of orders were cancelled versus completed
• show monthly revenue totals grouped by month
• get the top 3 highest spending customers with their total spend and order count
• how many orders have been placed
• how many customers are there in total
• list product names and prices only
• get just the names and emails of all customers
• find all orders with pending status
• find all products in the furniture category
• find all products that are in stock
• find all active customers
• find active users on the free plan
• find teams with more than 10 users
• find all inactive users
• count how many teams are on each plan
• find users who signed up in the last 30 days
• find teams that have no users
• count active users per team
• find all users on teams with the enterprise plan
• find published posts with more than 1000 views
• find the most recently published post for each author
• get the top 5 authors by total post views
• calculate the average number of views per author
• find posts that have both the tutorial and beginner tags
• count how many posts each author has written
• find authors who have not written any posts
• find posts published in the last 30 days
• get the 10 most viewed blog posts
• find all posts tagged with javascript
• get all orders for a specific customer sorted by date
• find products priced between $20 and $50
• count how many customers are active versus inactive
• find orders placed this month sorted by total descending
• find inactive customers who have placed orders before
• get the most recent order for each customer
• calculate total revenue grouped by product category
• find products that have never been ordered
• get the top 5 highest spending customers
• find orders containing more than 3 products
• calculate the average order value
• list products that are out of stock in the electronics category
• count orders grouped by status
• calculate total revenue per customer
• find customers who signed up but never placed an order
• get the 10 most expensive products
• find all orders over $100 placed in the last 7 days