Project 1

uploaded files

2.1 db.orders.aggregate([{$group:{_id:"$id",maxTotal:{$max:{$multiply: [ "$price","$items"]}},maxQuantity:{$max : "$items"}}}]) 2.2  db.orders.find({},{customer_id:1}).sort({price:-1}).limit(1) 2.3  db.orders.aggregate([{$group :{_id:0,sum:{$sum:"$price"}}}]) 2.4 db.Customers.aggregate([{$group :{_id:"$city","count":{$sum:1}}},{$sort:{_id:1}}])…

1.SELECT * FROM customers ORDER BY city; 2.ALTER Table customers Rename id to prod_id 3.SELECT customer_name, COUNT(DISTINCT product_ID) as products_count FROM customer_tableINNER JOIN orders_table ON customer_table.customer_ID = orders_table.customer_IDGROUP BY customer_table.customer_ID,…

import java.util.*;import java.io.*;public class Banking { public static void main(String[] args) { System.out.print("Welcome to Banking Management System\n"); Scanner in = new Scanner(System.in); // TODO Auto-generated method stub int loops=2; while(loops>0) { System.out.println("\nWant to open an account : Y/N");…

Attatched the files

I have attach the file.