Ver originalselect alumno_tipo, AVG(nota) as PROMEDIO from alumno, notas where alumno_id=id_alumno and nota <> 0 and nota <> 5 group by alumno_tipo, id_asignatura order by alumno_tipo