You will then need to import the sample piching.csv into your mongo database.

here is the csv file: https://www.dropbox.com/s/iqv95y3gofxkwpx/pitching.csv?dl=0

1.Find out the number of rows are in collection pitching

2.Count the number of records are in the year of 1872

3.Count the number of records that is between year of 1870 to 1880

4.Which player_id has the highest ipouts?

5.Find average year in the whole pitching collection

6.Group the players by year and return the average ipouts per year

7.Find out the players with max era and min era per year

8.Find out the average, maximun and minimum h and er per team_id

9.Find out the average, maximun and minimum h and er per team_id and year

10.Order the team_id by the number of players in the team and group by year