I want to rank the students based on the subject, and their total overall for that particular subject. Query works for all subjects but when I specify the where clause, I only get the rank of the user specified in…
So I got the following data: Users collection { _id: ObjectId("62a2a0422ec90fea68390aaa"), name: 'Robert Yamashita', username: 'robyama', email: '[email protected]', }, { _id: ObjectId("62a2a0452ec90fea68390aad"), name: 'Charles X', username: 'cvx', email: '[email protected]', } Points collection { userId: ObjectId("62a2a0422ec90fea68390aaa"), action: 'Liked a post', points:…