A mongoDB collection has the following structure:

{
"sid": 128,
"name": {
"first": "Drew",
"last": "Barrymore"
},
"course": "MasterAI",
"result": [
{
"unit_code": "FIT3182",
"unit_name": "Data processing for big data",
"synopsis":"This unit pertains to managing big data.",
"semester": 2,
"year": [ 2023 ],
"mark": 80
}
],
"yearOfUni": 3
}

Which of the following query finds out the number of students in each unit.

Question

A mongoDB collection has the following structure: 
 
 { 
 "sid": 128, 
 "name": { 
   "first": "Drew", 
   "last": "Barrymore" 
 }, 
 "course": "MasterAI", 
 "result": [ 
   { 
     "unit_code": "FIT3182", 
     "unit_name": "Data processing for big data", 
     "synopsis":"This unit pertains to managing big data.", 
     "semester": 2, 
     "year": [ 2023 ], 
     "mark": 80 
   } 
 ], 
 "yearOfUni": 3 
 } 
 
 Which of the following query finds out the number of students in each unit.

Answer

db.FIT_COMPLEX.aggregate({$group:{_id:"$result.unit_code", sum:{$count:1}}})

Answer

db.FIT_COMPLEX.aggregate({$group:{_id:"$course", sum:{$count:1}}})

Answer

db.FIT_COMPLEX.aggregate({$group:{_id:"$result.unit_code", count:{$sum:1}}})

Answer

db.FIT_COMPLEX.aggregate({$group:{_id:"$course", count:{$sum:1}}})

Crowdly

A mongoDB collection has the following structure: { "sid": 128, "name": ...

Want instant access to all verified answers on learning.monash.edu?