Prac 3

 3A)use dbs1

> db.createCollection ("Student")

> db. Student.insertMany([{"Name":"Ajay", "Age": 25, "Department":"IT", "City": "Mumbai", "Stipend":4000),{"Name":"Amir", "Age":24, "Department": "IT", "City":"Navi Mumbai", "Stipend": 5000), {"Name": "Ranveer", "Age":21, "Department":"CS", "City": "Palghar", "Stipend":16000), ("Name":"Rajkumar", "Age":26, "Department":"CS", "City":"Navi Mumbai", "Stipend":6000), {"Name": "Kriti", "Age":30,"Department": "IT", "City": "Palghar", "Stipend":3000),{"Name":"Ayesha", "Age":27, "Department":"CS", "City": "Mumbai", "Stipend":6000}])

db. Student.aggregate({$group: {_id:"$City", Age: {$max:"$Age"}}})

db. Student.aggregate({$group: {_id:"$City", Age: {$min:"$Age"}}})

db. Student.aggregate({$group: {_id:"$City", Age: {$sum:"$Age"}}})

db. Student.aggregate({$group: {_id:"$City", Stipendavg: {$avg:"$Stipend"}}})



3B)db.createCollection ("Order")

db.Order.insertMany([{"OrderId":101, "Product":"Shoes", "Quantity":1,"Price":500}, {"OrderId":102, "Product": "Sandal", "Quantity":2,"Price":500}, {"OrderId":103, "Product":"Shoes","Quantity":2,"Price":1000}])

db.Order.aggregate ([{$group: {_id:"$Product", Quantities: {$push: "$Quantity"}}}])

db.Order.aggregate ([{$group: {_id:"$Product", Unique_Price: {$addToSet:"$Price"}}}])




3C)db.OrderRecords.insertMany ([{"CusID":101, "OrderDate": ISODate("2025-07-01"), "Amount":250}, {"CusID":102, "OrderDate": ISODate("2025-07-18"),"Amount":500}, {"CusID":181, "Order Date": ISODate("2025-07-15"), "Amount":1000}])

db.OrderRecords.aggregate([{$group:{_id:"$CusID",First_OrderDate:{$first:"$OrderDate"},Last_OrderDate:{$last:"$OrderDate"}}}})

Comments

Post a Comment

Popular posts from this blog

Prac 5

 5Apackage com.example.MongoDB; import com.mongodb.client.MongoClient; import com.mongodb.client.MongoClients; import com.mongodb.client.MongoDatabase; public class MongoConnection { public static MongoDatabase connect() { String uri="mongodb://localhost:27017"; MongoClient mongoClient=MongoClients.create(uri); return mongoClient.getDatabase("dbs1"); } } 5B) package com.example.MongoDB; import org.bson.Document; import com.mongodb.client.MongoCollection; import com.mongodb.client.MongoDatabase; public class Mongo_Insert { public static void main(String[] args) { MongoDatabase database MongoConnection.connect(); MongoCollection<Document> collection=database.getCollection("Employee"); Document doc=new Document("Name", "Jyoti") .append("Age", 27).append("EmailId", "jyoti07@gmail.com"); collection.insertone(doc); System.out.println("Document inserted successfully!"); } 5C) package com.example.Mo...
Read more

Prac 1

 1A)use Krish drop.database() 1B)show dbs use Krish db.createcollection("emp") db.createcollection("emp1") show collections db.emp.drop() show collections  1C)use Krish db.createcollection("emp") db.emp.insertMany([{"Name":"Krish","Age":20,"email_id":"krish123@gmail.com"},{"Name":"Trish","Age":21,"email_id":"trish123@gmail.com"},{"Name":"Hrish","Age":22,"email_id":"hrish123@gmail.com"},{"Name":"Vrish","Age":23,"email_id":"vrish123@gmail.com"}]) db.emp.find() db.emp.updateOne({Name:"Krish"},{$set:{Age:24}) db.emp.deleteOne({Name:"Trish"}) Or use Krish db.createCollection("emp") db.emp.insertMany([   { "Name": "Krish", "Age": 20, "email_id": "krish123@gmail.com" },   { "Name...
Read more