prueba esto:
Código SQL:
Ver originalSELECT c.nomcurs,
r.anyo,
r.numordre,MIN(a.assistencia) AS min_ass,
MAX(a.assistencia) AS max_ass,
format(avg(a.assistencia),2) AS avg_ass,
MIN(a.nota) AS min_nota,
MAX(a.nota) AS max_nota,
format(avg(a.nota),2) AS avg_nota
FROM alumnescurs a, realitzaciocurs r, cursos c GROUP BY c.codicurs