Question: 1 . Write an aggregate statement to sort the documents in the grades collecion based on students ID and class ID . Display only the

1. Write an aggregate statement to sort the documents in the grades collecion based on students ID and class ID. Display only the student ID and the class ID for each document. Sort the result from high to low values for student ID and from low to high for class ID.
2. Revise the previous query to show the result for students with IDs between 10 and 12.
3. Show only existing class IDs in the grades collection. (Do not show duplicates.)
4. Write a query to display student ID and class ID for students whose score are greater than 99.00. Sort the result based on student ID from high to low and class ID from low to high.
5. Write a query to show the maximum and the minimum class ID for each student. Sort the result based on student ID from low to high. Show only the first 10 students.
See the following sample output:
{"_id" : 0, "max_class_id" : 30, "min_class_id" : 2}
{"_id" : 1, "max_class_id" : 28, "min_class_id" : 13}
{"_id" : 2, "max_class_id" : 27, "min_class_id" : 24}
{"_id" : 3, "max_class_id" : 25, "min_class_id" : 3}
{"_id" : 4, "max_class_id" : 26, "min_class_id" : 0}
{"_id" : 5, "max_class_id" : 30, "min_class_id" : 0}
{"_id" : 6, "max_class_id" : 29, "min_class_id" : 8}
{"_id" : 7, "max_class_id" : 17, "min_class_id" : 17}
{"_id" : 8, "max_class_id" : 29, "min_class_id" : 0}
{"_id" : 9, "max_class_id" : 30, "min_class_id" : 0}
6. Write a query to find the number of failed exams for student with ID 48.
Good luck.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!