Question

Each document in the collection contains the following fields: • The \_id field holds the zip code as a string. • The city field holds the city name. A city can have more than one zip code associated with it as different sections of the city can each have a different zip code. • The loc field holds the location as a latitude longitude pair. • The pop field holds the population. • The state field holds the two letter state abbreviation. Write queries for the following problems. 1. Find all the zip codes with population between 80000 and 85000 (List the \_id field and the pop field, and order the zip codes by their population in an ascending order). (2 Points) 2. Find all the zip codes in the \"WI\" state with population less than 100 or greater than 50000 (List the \_id field, the pop field and the state field, and order the zip codes by their population in a descending order). (2 Points) 3. Count the number of zip codes in the \"IN\" state. (2 Points) 4. Find all the states that have a city called DALLAS (Hint: please use the distinct operation). (2 Points) 5. Find the population of each city in the \"RI\" state (Hint: please use the aggregate operation). (2 points)

          Each document in the collection contains the following fields:
• The \_id field holds the zip code as a string.
• The city field holds the city name. A city can have more than one zip code associated with it
as different sections of the city can each have a different zip code.
• The loc field holds the location as a latitude longitude pair.
• The pop field holds the population.
• The state field holds the two letter state abbreviation.
Write queries for the following problems.
1. Find all the zip codes with population between 80000 and 85000 (List the \_id field and the pop
field, and order the zip codes by their population in an ascending order). (2 Points)
2. Find all the zip codes in the \"WI\" state with population less than 100 or greater than 50000 (List
the \_id field, the pop field and the state field, and order the zip codes by their population in a
descending order). (2 Points)
3. Count the number of zip codes in the \"IN\" state. (2 Points)
4. Find all the states that have a city called DALLAS (Hint: please use the distinct operation). (2
Points)
5. Find the population of each city in the \"RI\" state (Hint: please use the aggregate operation). (2
points)

Each document in the collection contains the following fields:
• The 𝕀field holds the zip code as a string.
• The city field holds the city name. A city can have more than one zip code associated with it
as different sections of the city can each have a different zip code.
• The loc field holds the location as a latitude longitude pair.
• The pop field holds the population.
• The state field holds the two letter state abbreviation.
Write queries for the following problems.
1. Find all the zip codes with population between 80000 and 85000 (List the 𝕀field and the pop
field, and order the zip codes by their population in an ascending order). (2 Points)
2. Find all the zip codes in the ẄIs̈tate with population less than 100 or greater than 50000 (List
the 𝕀field, the pop field and the state field, and order the zip codes by their population in a
descending order). (2 Points)
3. Count the number of zip codes in the ÏNs̈tate. (2 Points)
4. Find all the states that have a city called DALLAS (Hint: please use the distinct operation). (2
Points)
5. Find the population of each city in the R̈Is̈tate (Hint: please use the aggregate operation). (2
points)

Added by Alexis M.

Question

Please give Ace some feedback