No la he probado
Código sql:
Ver originalSELECT alumnos.nif, alumnos.nombre, t1.total totalpendientes
FROM alumnos INNER JOIN
(SELECT alumno, COUNT(*) total FROM examenes
WHERE evaluado = FALSE GROUP BY alumno HAVING total >=1 )t1
ON alumnos.nif = t1.alumno ORDER BY alumnos.nombre