Question

Please answer my questions and provide the correct answers it is an emergency because nobody has already answered my questions since I posted. Questions regarding MongoDB - Query. What are the answers to the following questions; you have to use the data document provided(database name: inventory, collection name: products), reading left to right. So basically, the data provided is a JSON file that you need to put in that database that you will create in MongoDB; therefore, I will put the JSON file at the bottom so that you can easily add in you MongoDB database.

{ "_id" : "ac3", "name" : "AC3 Phone", "brand" : "ACME", "type" : "phone", "price" : 200, "rating" : 3.8,"warranty_years" : 1, "available" : true }
{ "_id" : "ac7", "name" : "AC7 Phone", "brand" : "ACME", "type" : "phone", "price" : 320, "rating" : 4,"warranty_years" : 1, "available" : false }
{ "_id" : { "$oid" : "507d95d5719dbef170f15bf9" }, "name" : "AC3 Series Charger", "type" : [ "accessory", "charger" ], "price" : 19, "rating" : 2.8,"warranty_years" : 0.25, "for" : [ "ac3", "ac7", "ac9" ] }
{ "_id" : { "$oid" : "507d95d5719dbef170f15bfa" }, "name" : "AC3 Case Green", "type" : [ "accessory", "case" ], "color" : "green", "price" : 12, "rating" : 1,"warranty_years" : 0 }
{ "_id" : { "$oid" : "507d95d5719dbef170f15bfb" }, "name" : "Phone Extended Warranty", "type" : "warranty", "price" : 38, "rating" : 5,"warranty_years" : 2, "for" : [ "ac3", "ac7", "ac9", "qp7", "qp8", "qp9" ] }
{ "_id" : { "$oid" : "507d95d5719dbef170f15bfc" }, "name" : "AC3 Case Black", "type" : [ "accessory", "case" ], "color" : "black", "price" : 12.5, "rating" : 2,"warranty_years" : 0.25, "available" : false, "for" : "ac3" }
{ "_id" : { "$oid" : "507d95d5719dbef170f15bfd" }, "name" : "AC3 Case Red", "type" : [ "accessory", "case" ], "color" : "red", "price" : 12, "rating" : 4,"warranty_years" : 0.25, "available" : true, "for" : "ac3" }
{ "_id" : { "$oid" : "507d95d5719dbef170f15bfe" }, "name" : "Phone Service Basic Plan", "type" : "service", "monthly_price" : 40,"rating" : 3, "limits" : { "voice" : { "units" : "minutes", "n" : 400, "over_rate" : 0.05 }, "data" : { "units" : "gigabytes", "n" : 20, "over_rate" : 1 }, "sms" : { "units" : "texts sent", "n" : 100, "over_rate" : 0.001 } }, "term_years" : 2 }
{ "_id" : { "$oid" : "507d95d5719dbef170f15bff" }, "name" : "Phone Service Core Plan", "type" : "service", "monthly_price" : 60, "rating" : 3, "limits" : { "voice" : { "units" : "minutes", "n" : 1000, "over_rate" : 0.05 }, "data" : { "n" : "unlimited", "over_rate" : 0 }, "sms" : { "n" : "unlimited", "over_rate" : 0 } }, "term_years" : 1 }
{ "_id" : { "$oid" : "507d95d5719dbef170f15c00" }, "name" : "Phone Service Family Plan", "type" : "service", "monthly_price" : 90,"rating" : 4, "limits" : { "voice" : { "units" : "minutes", "n" : 1200, "over_rate" : 0.05 }, "data" : { "n" : "unlimited", "over_rate" : 0 }, "sms" : { "n" : "unlimited", "over_rate" : 0 } }, "sales_tax" : true, "term_years" : 2 }
{ "_id" : { "$oid" : "507d95d5719dbef170f15c01" }, "name" : "Cable TV Basic Service Package", "type" : "tv", "monthly_price" : 50, "rating" : 3.9,"term_years" : 2, "cancel_penalty" : 25, "sales_tax" : true, "additional_tarriffs" : [ { "kind" : "federal tarriff", "amount" : { "percent_of_service" : 0.06 } }, { "kind" : "misc tarriff", "amount" : 2.25 } ] }

warranty years: NaN available: false for: "ac3" _id: "507d95d5719dbef170f15bf9" name: "AC3 Series Charger" type: "accessory, charger" price: 19 rating: 2.8 warranty years: NaN > for: Array _id: "507d95d5719dbef170f15c00" name: "Phone Service Family Plan" type: "service" monthly price: 90 rating: NaN > limits: Object sales_tax: true term_years: 2 _id: "507d95d5719dbef178f15bfa" name: "AC3 Case Green" type: "accessory, case" color: "green" price: 12 rating: NaN warranty years: 0 _id: "507d95d5719dbef170f15bfd" name: "AC3 Case Red type: "accessory, case" color: "red" price: 12 rating: NaN warranty years: NaN available: true for: "ac3" _id: "507d95d5719dbef170f15c01" name: "Cable TV Basic Service Package" type: "tv" monthly_price: 50 rating: 3.9 term_years: 2 cancel_penalty: 25 sales_tax: true > additional_tarriffs: Array _id: "507d95d5719dbef170f15bfb" name: "Phone Extended Warranty" type: "warranty" price: 38 rating: NaN warranty years: 2 > for: Array _id: "507d95d5719dbef170f15bfe" name: "Phone Service Basic Plan" type: "service" monthly price: 40 rating: NaN > limits: Object term_years: 2 _id: "ac3" name: "AC3 Phone" brand: "ACME" type: "phone" price: 200 rating: 3.8 warranty years: 1 available: true _id: "507d95d5719dbef170f15bfc" name: "AC3 Case Black" type: "accessory, case" color: "black" price: NaN rating: NaN _id: "507d95d5719dbef170f15bff" name: "Phone Service Core Plan" type: "service" monthly price: 60 rating: NaN > limits: Object term_years: 1 _id: "ac7" name: "AC7 Phone" brand: "ACME" type: "phone" price: 320 rating: NaN warranty_years: 1 available: false

Answer 1

Answer 1)

The Query to Find the name and price of each product is below:

db.products.find( { } , {name:1, price: 1});

We use the find method in which first argument is passed empty which is the query criteria we want to apply and second is the projection that is which column we want to display set those to 1

Answer 2)

db.inventory.find({ type : { $eq: "accessory"} } , { name:1 , price: 1 });

Answer 3)

db.products.find( { price : { $range: [ 12, 21, 1] }} , {name:1, price: 1});

Here I have used the $range operator to find price between 12 and 21.

Answer 4)

db.products.find( {type: {$ne: "accessory"} } , { id:1, name:1, price: 1, type:1 });

I have used the $ne which is not equal to operator for this query.