[firebase-br] Problema com Avg

[Tallys Ferrante]

Dá o seguinte erro

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid expression in the select list (not contained in either an aggregate
function or the GROUP BY clause).

olha como ficou

SELECT
    MOV.FUNC_ID,
    MOV.PROJ_ID,
    MOV.ATIV_ID,
    MOV.ATIV_DATA,
    MOV.PROJ_DATA,
    AVG(MOV.MOV_PRODUCAO),
    MOV.MOV_OBS
FROM MOVIMENTACAO MOV
JOIN FUNCIONARIOS FUNC ON (MOV.FUNC_ID = FUNC.FUNC_ID)
GROUP BY FUNC.FUNC_ID, MOV.ATIV_ID;