Good morning everyone,
I am a beginner and I'm trying to understand OpenDB, I have a strong background in MySQL and I have some questions, first of all, some context:
We are trying to get data from retention center about students, we expect to get a comparison of student average vs class average for a few courses. Here are our questions:
- While looking at the institution's database, the tables for Retention Center are empty. I used the following query:
SELECT * FROM BBLEARN.retention_center_stage_grade
The other retention_center tables are empty as well, is this normal? Am I looking at the wrong tables?
- After doing some more digging, I found out that the average scores for courses are stored in ews_gradebook_main, but I cannot find the average scores for each student. Does OpenDB keep the average grades on a table? Or do we have to calculate it? This question is a backup plan in case the retention center data is not being recorded for some reason.
Thanks for your time in advance,
Gabriel Felix