Asnswer $20$ questions using NoSQL and this database in the picture:

Q$1$: Find the total number of orders placed by each customer.

$//$ Q$2$: List all customers who have placed more than $2$ orders.

$//$ Q$3$: Find the total sales amount for each sales representative.

$//$ Q$4$: List all products with a price greater than $$200.$

$//$ Q$5$: Find the average price of products in each category.

$//$ Q$6$: Count the number of products that have stock quantity less than $50.$

$//$ Q$7$: Find all orders with a total amount greater than $$300.$

$//$ Q$8$: List all suppliers located in the USA.

$//$ Q$9$: Find the maximum price of any product.

$//$ Q$10$: List all products supplied by 'Office World'.

$//$ Q$11$: Count the number of distinct categories of products.

$//$ Q$13$: List all orders along with the products ordered in each.

$//$ Q$14$: Find the total quantity of 'Keyboard' sold.

$//$ Q$16$: List all products ordered by each customer.

$//$ Q$17$: Find the total revenue generated by each product category.

$//$ Q$18$: Find the total number of orders with status 'Shipped'.

$//$ Q$19$: Find the products that have been ordered more than $5$ times.

$//$ Q$20$: Find the average quantity ordered for each product. $//$ Create Customers collection

db$.$Customers.insertMany$([$

Country: 'USA', SalesRepID: $2\},$

SalesRepID: $1\},$

'Canada', SalesRepID: $3\},$

'Canada', SalesRepID: $2\},$

SalesRepID: $1\},$

'Canada', SalesRepID: $3\},$

'USA', SalesRepID: $2\},$

Country: 'USA', SalesRepID: $1\},$

'Canada', SalesRepID: $3\},$

'USA', SalesRepID: $2\}$

$])$; db$.$Orders.insertMany$([\{$ OrderID: $2,$ CustomerID: $5,$ OrderDate: new Date$(\text{'}2024-06-02\text{'}),$ Status: 'Pending', ShippingDate: null, TotalAmount: $200\mathrm{.}00,$ SalesRepID: $2\},\{$ OrderID: $4,$ CustomerID: $2,$ OrderDate: new Date$(\text{'}2024-06-04\text{'}),$ Status: 'Cancelled', ShippingDate: null, TotalAmount: $100\mathrm{.}00,$ SalesRepID: $2\},\{$ OrderID: $6,$ CustomerID: $4,$ OrderDate: new Date$(\text{'}2024-06-06\text{'}),$ Status: 'Shipped', ShippingDate: new Date$(\text{'}2024-06-12\text{'}),$ TotalAmount: $400\mathrm{.}00,$ SalesRepID: $3\},\{$ OrderID: $8,$ CustomerID: $6,$ OrderDate: new Date$(\text{'}2024-06-08\text{'}),$ Status: 'Delivered', ShippingDate: new Date$(\text{'}2024-06-13\text{'}),$ TotalAmount: $450\mathrm{.}00,$ SalesRepID: $2\},])$;$//$ Create Products collection

db$.$Products.insertMany$([\{$ ProductID: $2,$ ProductName: 'Keyboard', Category: 'Accessories', StockQuantity: $300,$ Price: $29\mathrm{.}99\},\{$ ProductID: $4,$ ProductName: 'Desk', Category: 'Furniture', StockQuantity: $40,$ Price: $399\mathrm{.}99\},\{$ ProductID: $6,$ ProductName: 'Headphones', Category: 'Electronics', StockQuantity: $200,$ Price: $89\mathrm{.}99\},\{$ ProductID: $8,$ ProductName: 'Printer', Category: 'Office Supplies', StockQuantity: $60,$ Price: $149\mathrm{.}99\},\{$ ProductID: $10,$ ProductName: 'Laptop', Category: 'Electronics', StockQuantity: $50,$ Price: $999\mathrm{.}99\}$

$])$; db$.$OrderDetails.insertMany$([\{$ OrderDetailID: $2,$ OrderID: $2,$ ProductID: $6,$ Quantity: $4,$ UnitPrice: $199\mathrm{.}99\},\{$ OrderDetailID: $4,$ OrderID: $4,$ ProductID: $9,$ Quantity: $3,$ UnitPrice: $19\mathrm{.}99\},\{$ OrderDetailID: $6,$ OrderID: $6,$ ProductID: $7,$ Quantity: $1,$ UnitPrice: $499\mathrm{.}99\},\{$ OrderDetailID: $8,$ OrderID: $8,$ ProductID: $3,$ Quantity: $1,$ UnitPrice: $99\mathrm{.}99\},])$;$//$ Create Suppliers collection

db$.$Suppliers.insertMany$([\{$ SupplierID: $2,$ SupplierName: 'Office World', ContactName: 'Jane Smith', ContactEmail: 'jane.smith@officeworld.com', Phone: $\text{'}234-567-8901\text{'},$ Country: 'USA' $\},])$;$//$ Create ProductSuppliers collection

db$.$ProductSuppliers.insertMany$([\{$ ProductID: $2,$ SupplierID: $2\},\{$ ProductID: $4,$ SupplierID: $3\},\{$ ProductID: $6,$ SupplierID: $4\},\{$ ProductID: $8,$ SupplierID: $2\},\{$ ProductID: $10,$ SupplierID: $1\}$

$])$;