Southern New Hampshire University8-1 Assignment: Data Aggre

Southern New Hampshire University8-1 Assignment: Data Aggregation PipelineCS 340 09:03:18 GMT -05:001. Using the mongoimport tool, create thedatabase “companies” by loading the documents found in the “companies.json” file into the “research” collection. This file is located in the “/usr/local/datasets/” directory in Apporto. Verify your load by issuing the followingqueries:a. db.research.find({"name" : "AdventNet"})b. db.research.find({"founded_year" : 1996},{"name" :1}).limit(10) 09:03:18 GMT -05:002. Perform the following tasks using MongoDB queries:a. List only the first 20 names of companies founded after the year 2010, ordered alphabetically.b. List only the first 20 names of companies with offices in either California or Texas, ordered by the number of employees and sorted largest to smallest.Provide screenshots of your statements and the results as evidence.3. Design and implement a MongoDB aggregation pipeline to show the total number of offices by state for all companies that have offices in the United States. Be sure that you account for the fact that some companies have offices in several states. Explain your aggregation 09:03:18 GMT -05:00pipeline.Provide screenshots of your statements and the results as evidence.I chose unwind to create documents for company offices. I used match and filtered out all companies without