Question

write the following in MongoDB NoSQL:

a. For each year played, list a count of games in which John David Crow played.

select year, count(*) from profiles natural join games where name=”John David Crow” group by year;

b. In 1990, in what games and what Seattle players had interceptions in a game?

Select games.game_number, profiles.name from games, profiles where games.defense_interceptions <>0 and games.team=”SEA” and games.year=”1990” and games.player_id = profiles.player_id;

Answer 1

a)

db.profiles.aggregate( [ { $group : { _id : "$year", count: { $sum: 1 } } }, // Second Stage { $match: { "name": "John David Crow" } } ] )

NOTE: As per Chegg policy I am allowed to answer specific number of questions (including sub-parts) on a single post. Kindly post the remaining questions separately and I will try to answer them. Sorry for the inconvenience caused.