USE iMartADW
GO


Select cr.academic_year_id, count(*) AS Grades
from dbo.rpt_Student_Class_Roster cr
join dbo.lkp_LEA_Course c
  on cr.LEA_Course_Id = c.LEA_Course_Id
where 1=1
and cr.School_Unique_Id = '671-0197'
and c.Course_Subject_Id IN (17, 14, 16, 23, 26, 24)
and cr.Final_Numeric_Grade IS NOT NULL
group by cr.Academic_Year_Id