Table

assignmentsubmissions

Each row represents a single learner submission to a graded assignment, including grade, comment count, and license context.

statusgroupRedshift

Each row represents a single learner submission to a graded assignment, including grade, comment count, and license context.

Full schema

Yes, this table includes a statusgroup column. See Status Group for details.

select
  t.courseid,
  t.userid,
  t.assignmentid,
  t.grade,
  t.commentscount
from assignmentsubmissions as t
limit 100