Dadas as tabelas a seguir:Qual o comando que calcula a méd

A AVG(TABELA_ALUNO.NOTA) FROM TABELA_ALUNO AS ALUNO, TABELA_TURMA AS TURMA, TABELA_PROFESSOR AS PROFESSOR WHERE ALUNO.Turma = TURMA.ID AND TURMA.Professor = PROFESSOR.ID AND PROFESSOR.ID = 12   B SELECT AVG(TABELA_ALUNO.NOTA) FROM TABELA_ALUNO AS ALUNO, TABELA_TURMA AS TURMA, TABELA_PROFESSOR AS PROFESSOR WHERE ALUNO.Turma = TURMA.ID AND TURMA.Professor = PROFESSOR.ID AND PROFESSOR.ID = 12 C SELECT AVERAGE(ALUNO.NOTA) FROM TABELA_ALUNO AS ALUNO, TABELA_TURMA AS TURMA, TABELA_PROFESSOR AS PROFESSOR WHERE ALUNO.Turma = TURMA.ID AND TURMA.Professor = PROFESSOR.ID AND PROFESSOR.ID = 12  D SELECT AVG(ALUNO.NOTA) FROM TABELA_ALUNO AS ALUNO, TABELA_TURMA AS TURMA, TABELA_PROFESSOR AS PROFESSOR WHERE ALUNO.Turma = TURMA.ID AND TURMA.Professor = PROFESSOR.ID AND PROFESSOR.ID = 12 E SELECT AVERAGE (TABELA_ALUNO.NOTA) FROM TABELA_ALUNO, TABELA_TURMA, TABELA_PROFESSOR WHERE TABELA_ALUNO.Turma = TABELA_TURMA.ID AND TABELA_TURMA.Professor = TABELA_PROFESSOR.ID AND TABELA_PROFESSOR.ID = 12