Table

competencyassessmentattempts

Each row represents one attempt by a user on a competency assessment, including scores, pass/fail, and timing.

statusgroupRedshift

Each row represents one attempt by a user on a competency assessment, including scores, pass/fail, and timing.

Full schema

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

select
  t.answeredcount,
  t.competencyassessmentid,
  t.userid,
  t.grade,
  t.correctanswercount
from competencyassessmentattempts as t
limit 100