# M101P HOMEWORK HOMEWORK 5.1

Then import into your blog database as follows:. You need to group twice to solve this problem. Import it into your mongod using the following command from the command line:. For example, to extract the first digit from the city field, you could write this query:. You can download the handout and perform your analysis on your machine with.

For this set, there are only documents and zip codes , and all of them are in New York, Connecticut, New Jersey, and California. To help you verify your work before submitting, the author with the fewest comments is Mariela Sherer and she commented times. You are commenting using your Twitter account. Fill in your details below or click an icon to log in: In this problem you will calculate the number of people who live in a zip code in the US where the city starts with a digit. The project operator can extract the first digit from any field.

Some students have three homework assignments, etc.

### MongodbChamps: MJ: MongoDB for Java Developers Homework

To help you verify your work before submitting, the author with the fewest comments is Mariela Sherer and she commented times. You will need to probably change m101p homework homework 5.1 projection to send more info through than just that first character. After that, you just need to sort. Leave a Reply Cancel reply Enter your comment here You need to group twice to solve this problem. For this problem, assume that a city name that appears in more than m101p homework homework 5.1 state represents two separate cities.

September 4, September 14, Sonali Kothari.

Notify me of new comments via email. You must figure out the GPA that each student has achieved in a class and then average those numbers to get a class average.

## M101J – M101P WEEK 5

Note that not all students in the same class have the same exact number of assessments. Those students achieved a class average of For this problem, we have used a subset of the data you previously used in zips. Also, you will need a filtering step m101p homework homework 5.1 get rid of all documents where the city does not start with a digital Using the m101p homework homework 5.1 framework, calculate the sum total of people who are living in a zip code where the city starts with a digit.

Then import into your blog database as follows:.

### Snip2Code – MP: MongoDB for Developers (Homework )

This involves calculating an average for each student in each class of all non-quiz assessments and then averaging those numbers to get a class average. If you imported it correctly, you can go to m101p homework homework 5.1 test database in the mongo shell and conform that.

Choose the answer below.

For example, to extract the first digit from the city field, you could write this query:. You can download the handout and perform your analysis on your machine with.

Your task is to calculate the class with the best average student performance.

Please calculate the average population of cities in California abbreviation CA and New York NY taken together with populations over 25, You are commenting using your Facebook account. The project operator can extract the first digit from any field. M101p homework homework 5.1 in your details below or click an icon to log in: Import it into your mongod using the following command from the command line:.

You are commenting using your Twitter account.

Now use the aggregation framework to calculate the author with the greatest number of comments. Email required Address never made public.

In this problem you will calculate the number of people who live in a zip code in the US where the city starts with a digit.

For this set, there are only documents and zip codesand all of them are in New York, Connecticut, New Jersey, and M101p homework homework 5.1. In this assignment you will use the aggregation framework to find the most frequent author of comments on your m101p homework homework 5.1.

Start by downloading the handout zip file for this problem. You are commenting using your WordPress.