CREATE FUNCTION qtdAlunosAprovadosReprovados(@Disciplina NUMERIC, @Turma NUMERIC)
RETURNS @query TABLE (
   alunos_ap NUMERIC,
   alunos_rp NUMERIC
)
AS
BEGIN
     DECLARE @Assignments TABLE
     (
	    ASSIGNMENT_ID NUMERIC
     );
     INSERT INTO @Assignments SELECT ASSIGNMENT_ID FROM Assignments WHERE term_TERM_ID = @Turma AND term_COURSE_ID = @Disciplina

	 DECLARE @Grades TABLE
     (
	    grade NUMERIC
     );
	 INSERT INTO @Grades SELECT grade FROM StudentAssignment WHERE ASSIGNMENT_ID IN (SELECT ASSIGNMENT_ID FROM @Assignments)

	 DECLARE @pAlunosAp NUMERIC
     SET @pAlunosAp = (SELECT count(*) FROM @Grades WHERE grade > 60)
	 DECLARE @pAlunosRp NUMERIC
     SET @pAlunosRp = (SELECT count(*) FROM @Grades WHERE grade < 60)

	 INSERT INTO @query VALUES( @pAlunosAp , @pAlunosRp )

	 RETURN
END