MongoDB Query Help

Database and Schema

db.instructor.insertMany( [ { "name": "Zhang", "dept_name": "CS", "salary": 68000, "teaches": [ { course_id: "CS-101", year: 2018 }, { course_id: "CS-347", year: 2018 } ] }, { "name": "Levy", "dept_name": "CS", "salary": 80000, "teaches": [ { course_id: "CS-128", year: 2016 }, { course_id: "CS-201", year: 2017 } ] }, { "name": "Brandt", "dept_name": "Finance", "salary": 90000, "teaches": [ { course_id: "FIN-201", year: 2016 }, { course_id: "FIN-301", year: 2017 }, { course_id: "FIN-320", year: 2017 } ] }, { "name": "Davis", "dept_name": "Finance", "salary": 78000, "teaches": [ { course_id: "FIN-102", year: 2017 }, { course_id: "FIN-200", year: 2018 } ] }, { "name": "Crick", "dept_name": "Biology", "salary": 92000, "teaches": [ { course_id: "BIO-101", year: 2017 }, { course_id: "BIO-301", year: 2018 }, { course_id: "BIO-301", year: 2018 } ] }, { "name": "Williams", "dept_name": "Biology", "salary": 72000, "teaches": [ { course_id: "BIO-101", year: 2016 }, { course_id: "BIO-201", year: 2017 }, { course_id: "BIO-101", year: 2018 } ] } ] ); 


Queries

Give the MongoDB commands for the following queries and attach the result screenshot of each. 


a. Find the name, department name, and the salary of each instructor whose salary is at least 80,000 and has taught three courses. If an instructor has taught the same course N times, it is counted as N courses. 


b. Find the name and department name of each instructor who taught in both 2017 and 2018 and sort the results alphabetically by name. 


c. Find the total salary of each department and sort the result in the ascending order of the total salary. The result should only display department name and the total salary



Contact us for MongoDB Assignment help, MongoDB Homework Help, MongoDB Query help 

Want to know your assignment price quote please send your assignment file at contact@codersarts.com and our sales team will contact you as soon as assignment received.

Contact Us

Tel: (+91) 0120  4118730  

Time :   10 : 00  AM -  08 : 00 PM IST 

Registered address: G-69, Sector 63, 

 Noida - 201301, India

We Provide Services Across The different countries

USA    Australia   Canada   UK    UAE    Singapore   New Zealand    Malasia   India   Ireland   Germany

CodersArts is a Product by Sofstack Technology Solutions Pvt. Ltd.

  • CodersArts | Linkedin
  • Instagram