use iMartStage
go

select top 100 c.name, gra.*, tc.*
from icde.gradingscore gra
join icde.person stu
  on (gra.personID = stu.personID and gra.said = stu.said)
join icde.section sec
  on (gra.sectionID = sec.sectionID and gra.said = sec.said)
join icde.course c
  on (sec.courseID = c.courseID and sec.said = c.said)
join icde.gradingtask gt
  on (gra.taskID = gt.taskID and gra.said = gt.said)
join icde.transcriptcourse tc
  on (gra.scoreID = tc.scoreID and gra.said = tc.said)
where 1=1
  and stu.said = '710-ICDE'
  and stu.stateID = '1546601878'
  and sec.teacherDisplay LIKE '%Barth%'
  and gt.taskid = 3