[Q-1]
> db.user.find()
{ "_id" : ObjectId("59ba31772515ce6bd280eccd"), "Userid" : 1, "Data_of_join" : "sep 8,2016", "Education" : [ "BCA", "MCA" ], "Hobby" : [ "paying songs", "music" ], "job_category" : "manager", "Gender" : "male" }
{ "_id" : ObjectId("59ba317d2515ce6bd280ecce"), "Userid" : 2, "Data_of_join" : "jan 08,2014", "Education" : [ "BCA", "MCA" ], "Hobby" : [ "paying songs", "music" ], "job_category" : "analyst", "Gender" : "female" }
{ "_id" : ObjectId("59ba31802515ce6bd280eccf"), "Userid" : 3, "Data_of_join" : "march 07,2009", "Education" : [ "BCA", "MCA" ], "Hobby" : [ "paying songs", "music" ], "job_category" : "coder", "Gender" : "female" }
{ "_id" : ObjectId("59ba31bb2515ce6bd280ecd0"), "Userid" : 4, "Data_of_join" : "fab 10,2011", "Education" : [ "BCA", "MCA" ], "Hobby" : [ "paying songs", "music" ], "job_category" : "designer", "Gender" : "male" }
{ "_id" : ObjectId("59ba31e52515ce6bd280ecd1"), "Userid" : 5, "Data_of_join" : "march 07,2009", "Education" : [ "BCA", "MCA" ], "Hobby" : [ "paying songs", "music" ], "job_category" : "tester", "Gender" : "female" }
> db.user.count({Hobby:"paying songs"})
[Q-2]
>db.Movies.find()
{ "_id" : ObjectId("59ba3be92515ce6bd280ecd2"), "movieId" : 1, "movieName" : "wanted", "actors" : [ { "actorName" : "salman", "gender" : "male", "roleName" : "Hero" } ], "releaseYear" : 2010 }
{ "_id" : ObjectId("59ba3d5c2515ce6bd280ecd3"), "movieId" : 1, "movieName" : "wanted", "actors" : [ { "reviewID" : "10", "reviewDate" : "sep 08 2010", "reviewerName" : "ravi", "reviewRating" : "3 star", "reviwComment" : "NiceMovie" } ] }
{ "_id" : ObjectId("59ba3dcd2515ce6bd280ecd4"), "movieId" : 2, "movieName" : "veer", "actors" : [ { "reviewID" : "11", "reviewDate" : "sep 10 2011", "reviewerName" : "ravi", "reviewRating" : "5 star", "reviwComment" : "NiceMovie" } ] }
{ "_id" : ObjectId("59ba3ec22515ce6bd280ecd5"), "movieId" : 3, "movieName" : "razz", "actors" : [ { "reviewID" : "9", "reviewDate" : "jan 7 2015", "reviewerName" : "ravi", "reviewRating" : "2 star", "reviwComment" : "NiceMovie" } ] }
{ "_id" : ObjectId("59ba3efd2515ce6bd280ecd6"), "movieId" : 4, "movieName" : "tum", "actors" : [ { "reviewID" : "8", "reviewDate" : "fab 05 2013", "reviewerName" : "ravi", "reviewRating" : "1 star", "reviwComment" : "NiceMovie" } ] }
>
> db.user.find()
{ "_id" : ObjectId("59ba31772515ce6bd280eccd"), "Userid" : 1, "Data_of_join" : "sep 8,2016", "Education" : [ "BCA", "MCA" ], "Hobby" : [ "paying songs", "music" ], "job_category" : "manager", "Gender" : "male" }
{ "_id" : ObjectId("59ba317d2515ce6bd280ecce"), "Userid" : 2, "Data_of_join" : "jan 08,2014", "Education" : [ "BCA", "MCA" ], "Hobby" : [ "paying songs", "music" ], "job_category" : "analyst", "Gender" : "female" }
{ "_id" : ObjectId("59ba31802515ce6bd280eccf"), "Userid" : 3, "Data_of_join" : "march 07,2009", "Education" : [ "BCA", "MCA" ], "Hobby" : [ "paying songs", "music" ], "job_category" : "coder", "Gender" : "female" }
{ "_id" : ObjectId("59ba31bb2515ce6bd280ecd0"), "Userid" : 4, "Data_of_join" : "fab 10,2011", "Education" : [ "BCA", "MCA" ], "Hobby" : [ "paying songs", "music" ], "job_category" : "designer", "Gender" : "male" }
{ "_id" : ObjectId("59ba31e52515ce6bd280ecd1"), "Userid" : 5, "Data_of_join" : "march 07,2009", "Education" : [ "BCA", "MCA" ], "Hobby" : [ "paying songs", "music" ], "job_category" : "tester", "Gender" : "female" }
> db.user.count({Hobby:"paying songs"})
[Q-2]
>db.Movies.find()
{ "_id" : ObjectId("59ba3be92515ce6bd280ecd2"), "movieId" : 1, "movieName" : "wanted", "actors" : [ { "actorName" : "salman", "gender" : "male", "roleName" : "Hero" } ], "releaseYear" : 2010 }
{ "_id" : ObjectId("59ba3d5c2515ce6bd280ecd3"), "movieId" : 1, "movieName" : "wanted", "actors" : [ { "reviewID" : "10", "reviewDate" : "sep 08 2010", "reviewerName" : "ravi", "reviewRating" : "3 star", "reviwComment" : "NiceMovie" } ] }
{ "_id" : ObjectId("59ba3dcd2515ce6bd280ecd4"), "movieId" : 2, "movieName" : "veer", "actors" : [ { "reviewID" : "11", "reviewDate" : "sep 10 2011", "reviewerName" : "ravi", "reviewRating" : "5 star", "reviwComment" : "NiceMovie" } ] }
{ "_id" : ObjectId("59ba3ec22515ce6bd280ecd5"), "movieId" : 3, "movieName" : "razz", "actors" : [ { "reviewID" : "9", "reviewDate" : "jan 7 2015", "reviewerName" : "ravi", "reviewRating" : "2 star", "reviwComment" : "NiceMovie" } ] }
{ "_id" : ObjectId("59ba3efd2515ce6bd280ecd6"), "movieId" : 4, "movieName" : "tum", "actors" : [ { "reviewID" : "8", "reviewDate" : "fab 05 2013", "reviewerName" : "ravi", "reviewRating" : "1 star", "reviwComment" : "NiceMovie" } ] }
>
Fabulous
ReplyDelete