Consider the collection table1 below.

{
"_id" : ObjectId("5285bd678154c4747b705b4f"),
"item_code" : "I001",
"category" : [
"boy",
"girl"
],
"description" : [
{
"agegroup" : "3-5",
"flavour" : "chocolate",
"price" : 5
},
{
"agegroup" : "6-9",
"flavour" : "strawberry",
"price" : 6
},
{
"agegroup" : "10-13",
"flavour" : "mango",
"price" : 7
}
]
}
{
"_id" : ObjectId("5285bd808154c4747b705b50"),
"item_code" : "I002",
"category" : [
"boy",
"girl"
],
"description" : [
{
"agegroup" : "3-5",
"flavour" : "vanilla",
"price" : 3
},
{
"agegroup" : "6-9",
"flavour" : "lemon",
"price" : 6
},
{
"agegroup" : "10-13",
"flavour" : "mango",
"price" : 5
}
]
}

Select all documents from the collection "table1" which satisfy the following conditions:
The age group must be within "10-13"
The price must be more than or equal to 7

Question

Consider the collection table1 below. 
 
 { 
  "_id" : ObjectId("5285bd678154c4747b705b4f"), 
  "item_code" : "I001", 
  "category" : [ 
  "boy", 
  "girl" 
  ], 
  "description" : [ 
  { 
  "agegroup" : "3-5", 
  "flavour" : "chocolate", 
  "price" : 5 
  }, 
  { 
  "agegroup" : "6-9", 
  "flavour" : "strawberry", 
  "price" : 6 
  }, 
  { 
  "agegroup" : "10-13", 
  "flavour" : "mango", 
  "price" : 7 
  } 
  ] 
 } 
 { 
  "_id" : ObjectId("5285bd808154c4747b705b50"), 
  "item_code" : "I002", 
  "category" : [ 
  "boy", 
  "girl" 
  ], 
  "description" : [ 
  { 
  "agegroup" : "3-5", 
  "flavour" : "vanilla", 
  "price" : 3 
  }, 
  { 
  "agegroup" : "6-9", 
  "flavour" : "lemon", 
  "price" : 6 
  }, 
  { 
  "agegroup" : "10-13", 
  "flavour" : "mango", 
  "price" : 5 
  } 
  ] 
 }

Select all documents from the collection "table1" which satisfy the following conditions: 
 The age group must be within "10-13" 
 The price must be more than or equal to 7

Answer

None of these

Answer

db.table1.find( { "description": { $elemMatch: { "agegroup" : {$gte:10 , $lte:13},"price":{$gte:7}}}}).pretty()

Answer

db.table1.find( { "description": { $elemMatch: { "agegroup" : {$gte:10 , $lte:13}}  ,$elemMatch: {"price":{$gte:7}}}}).pretty()

Answer

db . table1 . find (  {  "description" : { $elemMatch: {  "agegroup"  :  "10-13" , "price" :{$gte: 7 }}}} ) . pretty ( )

Crowdly

Consider the collection table1 below. { "_id" : ObjectId("5285bd678154c47...

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