Task $2(12\mathrm{.}0$ marks$)$

Aggregation and Data manipulations on BSON documents

If you have not done it yet, start Mongo client and connect to the MongoDB database server. Next, process the script file customerShoppingcartV$2.$js to create the BSON documents into a collection shoppingCart. Each of the following questions is worth $1\mathrm{.}5$ marks. Make yourself familiar with the contents of the collections.

List the customer's name, address and the created shopping cart who purchased product P$1003.$

List the customer's name, address, and the created shopping cart of the customer who created a shopping cart on $11$ May $2024($ISODate$(\text{'}2024-0511$T$00$:$00$:$00$Z$\text{'})).$ Please do not show the customer's id$.$

Find the total number of shopping carts created by each customer. For each customer, list his$/$her email address and the total number of shopping cart created.

Find the products that have been included in at least $2$ or $3$ shopping carts.

For each price base, list the price base and the total number of each price base.

Find the customers who have purchased both the products $\text{'}$P$1002\text{'}$ and $\text{'}$P$1003\text{'}.$

Find the products that have not been included in any of the shopping carts.

Find the total number of customers who do not provide his$/$her telephone number.

Update the closing date $($dateClosed$)$ of the cart 'cart$001\text{'}$ of the customer $\text{'}$C$92378\text{'}$ to $15$ May $2024.($Hint$.$ You can use the function new Date$("2024-{0515}^{\text{'}\text{'}}$ to set the date.$)$

$10.$Delete from the collection a shoppingcart $($cart$005)$ created by the customer C$78263.$