Operator Logika

 Operator Logika

1.

db.products.insertMany([

{ "_id" : 1, "name" : "xPhone", "price" : 799, "releaseDate" : ISODate("2011-05-14T00:00:00Z"), "spec" : { "ram" : 4, "screen" : 6.5, "cpu" : 2.66 }, "color" : [ "white", "black" ], "storage" : [ 64, 128, 256 ] },

{ "_id" : 2, "name" : "xTablet", "price" : 899, "releaseDate" : ISODate("2011-09-01T00:00:00Z"), "spec" : { "ram" : 16, "screen" : 9.5, "cpu" : 3.66 }, "color" : [ "white", "black", "purple" ], "storage" : [ 128, 256, 512 ] },

{ "_id" : 3, "name" : "SmartTablet", "price" : 899, "releaseDate" : ISODate("2015-01-14T00:00:00Z"), "spec" : { "ram" : 12, "screen" : 9.7, "cpu" : 3.66 }, "color" : [ "blue" ], "storage" : [ 16, 64, 128 ] },

{ "_id" : 4, "name" : "SmartPad", "price" : 699, "releaseDate" : ISODate("2020-05-14T00:00:00Z"), "spec" : { "ram" : 8, "screen" : 9.7, "cpu" : 1.66 }, "color" : [ "white", "orange", "gold", "gray" ], "storage" : [ 128, 256, 1024 ] },

{ "_id" : 5, "name" : "SmartPhone", "price" : 599, "releaseDate" : ISODate("2022-09-14T00:00:00Z"), "spec" : { "ram" : 4, "screen" : 9.7, "cpu" : 1.66 }, "color" : [ "white", "orange", "gold", "gray" ], "storage" : [ 128, 256 ] },

{ "_id" : 6, "name" : "xWidget", "spec" : { "ram" : 64, "screen" : 9.7, "cpu" : 3.66 }, "color" : [ "black" ], "storage" : [ 1024 ] },

{ "_id" : 7, "name" : "xReader","price": null, "spec" : { "ram" : 64, "screen" : 6.7, "cpu" : 3.66 }, "color" : [ "black", "white" ], "storage" : [ 128 ] }

])

2.

db.products.find({

    price: {

        $eq: 899

    }

}, {

    name: 1,

    price: 1

})

3.

db.products.find({

    price: 899

}, {

    name: 1,

    price: 1

})

4.

db.products.find({

    "spec.ram": {

        $eq: 4

    }

}, {

    name: 1,

    "spec.ram": 1

})

5.

db.products.find({

    "spec.ram": 4

}, {

    name: 1,

    "spec.ram": 1

})

6.

db.products.find({

    color: {

        $eq: "black"

    }

}, {

    name: 1,

    color: 1

})

7.

db.products.find({

    color: "black"

}, {

    name: 1,

    color: 1

})

8.

db.products.find({

    releaseDate: {

        $eq: new ISODate("2020-05-14")

    }

}, {

    name: 1,

    releaseDate: 1

})

9.

db.products.find({

    price: {

        $gt: 699

    }

}, {

    name: 1,

    price: 1

})

10.

db.products.find({

    "spec.ram": {

        $gt: 8

    }

}, {

    name: 1,

    "spec.ram": 1

});

11.

db.products.find({

    storage: {

        $gt: 128

    }

}, {

    name: 1,

    storage: 1

})

12.

db.products.find({

    "releaseDate": {

        $gt: new ISODate('2015-01-01')

    }

}, {

    name: 1,

    releaseDate: 1

});