covert to MongoDB NoSQL a. In 1990, in what games and what Seattle players had interceptions in...

Free

80.2K

Verified Solution

Question

Programming

covert to MongoDB NoSQL
a. In 1990, in what games and what Seattle players hadinterceptions in a game?
Select games.game_number, profiles.name from games, profileswhere games.defense_interceptions <>0 and games.team=â€SEAâ€and games.year=â€1990â€ and games.player_id = profiles.player_id;
b. For each year played, list a count of games in which JohnDavid Crow played.
select year, count(*) from profiles natural join games wherename=â€John David Crowâ€ group by year;

Answer & Explanation Solved by verified expert

3.6 Ratings (428 Votes)

db.games,profiles .find({

Â Â \"$and\": [{
Â Â Â Â Â \"games.defense_interceptions <\":{ \"$gt\" : 0 }
Â Â },{
Â Â \"$and\": [{
Â Â Â Â Â \"$where\": \"this. games.team == this.â€SEAâ€ \"
Â Â },{
Â Â \"$and\": [{
Â Â Â Â Â \" games.year\" : â€1990â€
Â Â },{Â Â \"$where\": \"this. games.player_id == this. profiles.player_id\"
Â Â }]
Â Â }]
Â Â }]
},{
Â Â \"games.game_number\": 1,
Â Â \"profiles.name\": 1
}
);

db.profilesnatural join games .group({

\"key\":{
\"year\": true
},
\"initial\": {
\"countstar\":0
},
\"reduce\": function( obj , prev ){

if (true != null ) if ( true instanceof Array)prev.countstar += true.length;
else prev.countstar++;

},
\"finalize\": function( prev ){

},
\"cond\": {
Â Â \"$where\": \"this.name == this.â€John David Crowâ€ \"
}

});

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member