After completing the textbook reading and reviewing the module resources, complete the following tasks using the MongoDB shell. 1. Using the mongoimport tool, create the database "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 following queries: a. db.research.find({"name" : "AdventNet"}} b. db.research.find({"founded_year" : 1996},{"name" : 1}).limit(10) Provide screenshots of your statements and the results as evidence. 2. 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 employees by state for all companies that have offices in the United States. Provide screenshots of your statements and the results as evidence. After completing the textbook reading and reviewing the module resources, complete the following tasks using the MongoDB shell. 1. Using the mongoimport tool, create the database "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 following queries: a. db.research.find({"name" : "AdventNet"}} b. db.research.find({"founded_year" : 1996},{"name" : 1}).limit(10) Provide screenshots of your statements and the results as evidence. 2. 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 employees by state for all companies that have offices in the United States. Provide screenshots of your statements and the results as evidence