— from Matt Kacskos (mkacskos1 AT niu.edu) — Returns Course ID and the number of SA Submissions in that course Select cm.COURSE_ID, count(s.pk1) From mdb_safeassign_submission s join mdb_safeassign_item i on (s.mdb_sa_item_pk1 = i.pk1) join COURSE_MAIN cm on (cm.PK1 = i.crsmain_pk1) — WHERE (COURSE_ID like ‘1166-%’ or COURSE_ID like ‘MASTER-1166%’) group by cm.COURSE_ID order by cm.course_id ]]>
