EssayproSolutions

(Solved) : Cassandra Nosql Collection Want Find Student Got Max Grade Biology Course Try Dbcollection Q37203517 . . .

#Cassandra #NoSQL

Here is my collection, and I want to find the student who gotthe max grade in Biology course.

I try this:

db.collection.find({Course_Name: ‘Biology’}).sort({“Students.Grade” :-1 }).limit(1)

But nothing comes out… Can anyone tell me why and how to fixit? Thanks!!

—–Collections——–

{ Course_ID:13, Course_Name: ‘Biology’, Students:[ {student_id:001, First_Name:’Dave’, Last_Name: ‘Davis’, Grade: 78}, {student_id: 003, First_Name:’Thomas’, Last_Name: ‘Thompson’, Grade: 80} ]}

Expert Answer

Answer to #Cassandra #NoSQL Here is my collection, and I want to find the student who got the max grade in Biology course. I try t…