How do I compute student report sheet fetching records from the database

I have a DB table named ‘examMarks’ with various student’s scores, and i would like to compute result from it obtaining position/rank of student in each subject. After several googling, i found an SQL script that does something similar but i realized it only compute position/rank of each subject for all the students at a go not individual. Please i need help. Below is the screen-grab of the DB table and the script i have tried so far.

(SELECT COUNT(*) + 1 FROM examMarks ref WHERE ref.totalMarks > main.totalMarks) as rank,
id, subjectId, CA1Exam, CA2Exam, examMark, totalMarks, markComments
FROM examMarks main Where classId = ‘$classId’
AND session = ‘$session’ AND term = ‘$term’ AND studentId = ‘$studentId’
ORDER BY subjectId ASC);

Firstly, welcome to the forums.

While we are primarily here to help people with their Free Code Camp progress, we are open to people on other paths, too. Some of what you are asking is pretty trivial in the Free Code Camp context, so you might find that if you’re not getting the instruction and material you need in your current studies, the FCC curriculum will really help you get started. At a modest guess I’d say investing a 4-5 hours working through the curriculum here will really pay off. You can find the curriculum at

With your current questions, we don’t have enough context to know what you already know or don’t know, so it is impossible to guide you without just telling you the answer (which we won’t do).

It is pretty typical on here for people to share a codepen / / jsfiddle example of what they have tried so that anyone helping has more of an idea of what help is actually helpful.

Please provide some example of what you’ve tried and I’m sure you’ll get more help.

Happy coding :slight_smile:

Thank you @ArielLeslie for your response, I have provided the script I tried already…please see it above.