MongoDB is an open$-$source document$-$oriented database that is designed to store large scale data. It is categorised as a NoSQL $($Not only SQL$)$ database because the storage and retrieval of data in the MongoDB is not in the form of tables and querying does not have to be done using SQL$.$

Based on this document database, write queries in MongoDB for each of the following tasks.

a$.$ Display the customer id and customer name of all customers with a balance of $$0\mathrm{.}00$ and who are not from $$Christchurch$$ sorted by customer id$.$

b$.$ Display the customer id$,$ customer name, customer city and customer balance of all customers sorted by customer name in ascending order.

c$.$ Display the product name and product price for every product in the system. Sort the results by product name. Duplicates should be removed.

d$.$Display the product name and total for all orders made by customer number $1001$ sorted by total in descending order.

e$.$ Display the product name and product price for all products that cost greater than or equal to $$50\mathrm{.}00.$

f$.$ For each customer, display the customer$$s name, the number of order and the order total.

g$.$ Display the number of distinct products in the system.

h$.$ Display the product name and the product price for the product with highest price.

i$.$ Display the customer name for all customers who have never ordered a product.

j$.$Display all cities customers are based in and the number of customers in each city.

k$.$ Display the product name and total for all the product$($s$)$ ordered by $$John$.$

l$.$ Display the product name and the number of times each product has been ordered.

m$.$ Insert a new customer, $(10013,$Hans$,$Dunedin$,0\mathrm{.}00).$

n$.$ Insert a new order for Hans, $($Wenlock$,40,3,120\mathrm{.}00)$ and update the customer balance for Hans to $120\mathrm{.}00.$

$[\{$

$"\_$id$"$: $\{$

$"$$oid": $"66456$e$90222769052$b$2$ade$59"$

$\},$

"cust$\_$id$"$: $"1001",$

"cust$\_$name": "John",

"cust$\_$city": "Christchurch",

"cust$\_$balance": $200,$

"orders": $[$

$\{$

"prod$\_$name": "Albertine",

"prod$\_$price": $30,$

"prod$\_$qty$"$: $2,$

"total": $60$

$\},$

$\{$

"prod$\_$name": "Amelia",

"prod$\_$price": $39\mathrm{.}9,$

"prod$\_$qty$"$: $1,$

"total": $39\mathrm{.}9$

$\},$

$\{$

"prod$\_$name": "Allotria",

"prod$\_$price": $40,$

"prod$\_$qty$"$: $2,$

"total": $80$

$\}$

$]$

$\},$

$\{$

$"\_$id$"$: $\{$

$"$$oid": $"66456$f$68222769052$b$2$ade$5$a$"$

$\},$

"cust$\_$id$"$: $"1002",$

"cust$\_$name": "Hannah",

"cust$\_$city": "Christchurch",

"cust$\_$balance": $100,$

"orders": $[$

$\{$

"prod$\_$name": "Ausblush",

"prod$\_$price": $20,$

"prod$\_$qty$"$: $1,$

"total": $20$

$\},$

$\{$

"prod$\_$name": "Ausbord",

"prod$\_$price": $40,$

"prod$\_$qty$"$: $2,$

"total": $80$

$\}$

$]$

$\},$

$\{$

$"\_$id$"$: $\{$

$"$$oid": $"66456$fb$7222769052$b$2$ade$5$b$"$

$\},$

"cust$\_$id$"$: $"1003",$

"cust$\_$name": "Rita",

"cust$\_$city": "Christchurch",

"cust$\_$balance": $0,$

"orders": $[$

$\{$

"prod$\_$name": "Ausmas",

"prod$\_$price": $100,$

"prod$\_$qty$"$: $1,$

"total": $100$

$\},$

$\{$

"prod$\_$name": "Chaucer",

"prod$\_$price": $30,$

"prod$\_$qty$"$: $2,$

"total": $60$

$\}$

$]$

$\},$

$\{$

$"\_$id$"$: $\{$

$"$$oid": $"66457$ce$1222769052$b$2$ade$5$c$"$

$\},$

"cust$\_$id$"$: $"1004",$

"cust$\_$name": "Milly",

"cust$\_$city": "Wellington",

"cust$\_$balance": $20,$

"orders": $[$

$\{$

"prod$\_$name": "Leander",

"prod$\_$price": $10,$

"prod$\_$qty$"$: $5,$

"total": $50$

$\},$

$\{$

"prod$\_$name": "Lucetta",

"prod$\_$price": $10,$

"prod$\_$qty$"$: $1,$

"total": $10$

$\},$

$\{$

"prod$\_$name": "Chianti",

"prod$\_$price": $30,$

"prod$\_$qty$"$: $1,$

"total": $30$

$\},$

$\{$

"prod$\_$name": "Perditta",

"prod$\_$price": $30,$

"prod$\_$qty$"$: $2,$

"total": $60$

$\}$

$]$

$\},$

$\{$

$"\_$id$"$: $\{$

$"$$oid": $"66457$d$0$a$222769052$b$2$ade$5$d$"$

$\},$

"cust$\_$id$"$: $"1005",$

"cust$\_$name": "Angela",

"cust$\_$city": "Auckland",

"cust$\_$balance": $0,$

"orders": $[$

$\{$

"prod$\_$name": "Chianti",

"prod$\_$price": $30,$

"prod$\_$qty$"$: $2,$

"total": $60$

$\},$

$\{$

"prod$\_$name": "Chaucer",

"prod$\_$price": $30,$

"prod$\_$qty$"$: $2,$

"total": $60$

$\},$

$\{$

"prod$\_$name": "Leander",

"prod$\_$price": $10,$

"prod$\_$qty$"$: $10,$

"total": $100$

$\}$

$]$

$\},$

$\{$

$"\_$id$"$: $\{$

$"$$oid": $"66457$d$2$a$222769052$b$2$ade$5$e$"$

$\},$

"cust$\_$id$"$: $"1006",$

"cust$\_$name": "Barbara",

"cust$\_$city": "Dunedin",

"cust$\_$balance": $200,$

"orders": $[]$

$\},$

$\{$

$"\_$id$"$: $\{$

$"$$oid": $"66457$d$79222769052$b$2$ade$5$f$"$

$\},$

"cust$\_$id$"$: $"1007",$

"cust$\_$name": "Bradley",

"cust$\_$city": "Christchurch",

"cust$\_$balance": $0,$

"orders": $[$

$\{$

"prod$\_$name": "Chaucer",

"prod$\_$price": $30,$

"prod$\_$qty$"$: $2,$

"total": $60$

$\},$

$\{$

"prod$\_$name": "Perditta",

"prod$\_$price": $30,$

"prod$\_$qty$"$: $2,$

"total": $60$

$\},$

$\{$

"prod$\_$name": "Prospero",

"prod$\_$price": $50,$

"prod$\_$qty$"$: $3,$

"total": $150$

$\}$

$]$