Promedio y LEFT JOIN

[gnzsoloyo]

Sacar la media de la media, requeriría hacer una subconsulta que a su vez use el GROUP BY correspondiente.
Esto significa:

Código MySQL:

SELECT * 
FROM     
    (SELECT * 
    FROM 
        (SELECT 
            o0.id,
            o1.id,
            o2.id,
            o3.id,
            o4.id,
            IFNULL(AVG(t.evalua),0)  media
        FROM 
            ss_objetive AS o0
            LEFT JOIN ss_objetive AS o1 ON o1.dp = o0.id
            LEFT JOIN ss_objetive AS o2 ON o2.dp = o1.id
            LEFT JOIN ss_objetive AS o3 ON o3.dp = o2.id
            LEFT JOIN ss_objetive AS o4 ON o4.dp = o3.id
            LEFT JOIN ss_tareas AS t ON t.idopera = o4.id 
        WHERE o4.idges = 3 AND o4.tipo = 4 AND o4.idare = 65 
        GROUP BY o4.id) T1
    GROUP BY o3.id)T2
GROUP BY o2.id;