How do you extract grade from grading_standards.data where scores.course_score = true?

Pete5484
Community Participant

Wondering if anyone can suggest how to extract the equivalent of the grade book total letter grade?

In the scores table, scores.course_score is a boolean value where true "represents the overall score for the course referred to in the enrollment".

But it doesn't provide the letter grade. Instead it just links to the grading_standards table where the grading scheme is stored in grading_standards.data as json. 

The submissions table contains submissions.grade ("Letter grade mapped from the score by the grading scheme"). Why not do this for course _score? And override_score? It's in the rest api. 

It just seems unnecessarily complicated.

Anyway, wondering if anyone has any tips on doing this in SQL? 

 

Labels (3)
0 Likes