[ContraVeneno]

Código SQL [-]
 select Avg(Calif) as Prom
 from (select Puntos as Calif
          from Alum
          group by AlumID) Tabla --"Tabla" es un nombre temporal para tu subconsulta
 order by Prom

Código SQL [-]
select * 
from (select * from Tabla) temp