Execute the following query and save the results as an Excel file. Upload that file below. with ees as (select distinct u.user_id, cm.course_id, gg.pk1 ggpk1, gm.title, ee.pk1 eepk1 from users u left join course_users cu on u.pk1 = cu.USERS_PK1 left join course_main cm on cm.pk1 = cu.crsmain_pk1 left join gradebook_grade gg on gg.COURSE_USERS_PK1 = cu.pk1 left join gradebook_main gm on gm.pk1 = gg.GRADEBOOK_MAIN_PK1 left join attempt a on a.GRADEBOOK_GRADE_PK1 = gg.pk1 left join GROUP_ATTEMPT ga on ga.pk1 = a.GROUP_ATTEMPT_PK1 left join ATTEMPT_STAGED_GRADING asg on asg.ATTEMPT_PK1 = a.pk1 left join GROUP_ATTEMPT_STAGED_GRADING gasg on gasg.GROUP_ATTEMPT_PK1 = ga.pk1 left join EVALUATION_ENTITY ee on (ee.ATTEMPT_PK1 = a.pk1 or ee.GROUP_ATTEMPT_PK1 = ga.pk1 or ee.ATTEMPT_STAGED_GRADING_PK1 = asg.pk1 or ee.GRP_ATT_STAGED_GRADING_PK1 = gasg.pk1) where u.user_id = '' and cm.COURSE_ID = '' and ee.pk1 is not null) select ees.user_id, ees.course_id, ees.title gradebook_title, r.pk1 rubric_id, r.title rubric_title, re.pk1 evalpk1, re.SUBMISSION_DATE, rce.RUBRIC_CELL_PK1 eval_cell_pk1, coalesce(re.OVERRIDE_VALUE, re.TOTAL_VALUE) total_score, rcell.pk1 cell_pk1, rr.header row_header, rr.percentage row_weight, rc.HEADER as column_header, rcell.DESCRIPTION, rcell.NUMERIC_POINTS, rcell.PERCENTAGE, re.comments from ees left join rubric_link rl on rl.EVAL_ENTITY_PK1 = ees.eepk1 left join rubric r on r.pk1 = rl.RUBRIC_PK1 left join rubric_row rr on rr.RUBRIC_PK1 = r.pk1 left join rubric_column rc on rc.RUBRIC_PK1 = r.pk1 left join rubric_cell rcell on rcell.RUBRIC_COLUMN_PK1 = rc.pk1 and rcell.RUBRIC_ROW_PK1 = rr.pk1 left join rubric_eval re on re.RUBRIC_LINK_PK1 = rl.pk1 left join rubric_cell_eval rce on rce.RUBRIC_EVAL_PK1 = re.pk1 and rce.RUBRIC_ROW_PK1 = rr.pk1 where r.pk1 is not null order by ees.ggpk1, r.pk1, re.pk1, rr.position, rc.position;
with ees as (select distinct u.user_id, cm.course_id, gg.pk1 ggpk1, gm.title, ee.pk1 eepk1 from users u left join course_users cu on u.pk1 = cu.USERS_PK1 left join course_main cm on cm.pk1 = cu.crsmain_pk1 left join gradebook_grade gg on gg.COURSE_USERS_PK1 = cu.pk1 left join gradebook_main gm on gm.pk1 = gg.GRADEBOOK_MAIN_PK1 left join attempt a on a.GRADEBOOK_GRADE_PK1 = gg.pk1 left join GROUP_ATTEMPT ga on ga.pk1 = a.GROUP_ATTEMPT_PK1 left join ATTEMPT_STAGED_GRADING asg on asg.ATTEMPT_PK1 = a.pk1 left join GROUP_ATTEMPT_STAGED_GRADING gasg on gasg.GROUP_ATTEMPT_PK1 = ga.pk1 left join EVALUATION_ENTITY ee on (ee.ATTEMPT_PK1 = a.pk1 or ee.GROUP_ATTEMPT_PK1 = ga.pk1 or ee.ATTEMPT_STAGED_GRADING_PK1 = asg.pk1 or ee.GRP_ATT_STAGED_GRADING_PK1 = gasg.pk1) where u.user_id = '' and cm.COURSE_ID = '' and ee.pk1 is not null) select ees.user_id, ees.course_id, ees.title gradebook_title, r.pk1 rubric_id, r.title rubric_title, re.pk1 evalpk1, re.SUBMISSION_DATE, rce.RUBRIC_CELL_PK1 eval_cell_pk1, coalesce(re.OVERRIDE_VALUE, re.TOTAL_VALUE) total_score, rcell.pk1 cell_pk1, rr.header row_header, rr.percentage row_weight, rc.HEADER as column_header, rcell.DESCRIPTION, rcell.NUMERIC_POINTS, rcell.PERCENTAGE, re.comments from ees left join rubric_link rl on rl.EVAL_ENTITY_PK1 = ees.eepk1 left join rubric r on r.pk1 = rl.RUBRIC_PK1 left join rubric_row rr on rr.RUBRIC_PK1 = r.pk1 left join rubric_column rc on rc.RUBRIC_PK1 = r.pk1 left join rubric_cell rcell on rcell.RUBRIC_COLUMN_PK1 = rc.pk1 and rcell.RUBRIC_ROW_PK1 = rr.pk1 left join rubric_eval re on re.RUBRIC_LINK_PK1 = rl.pk1 left join rubric_cell_eval rce on rce.RUBRIC_EVAL_PK1 = re.pk1 and rce.RUBRIC_ROW_PK1 = rr.pk1 where r.pk1 is not null order by ees.ggpk1, r.pk1, re.pk1, rr.position, rc.position;