mysql版本问题导致group by报错

SELECT
    ANY_VALUE ( a.PREV_CODE ) AS PREV_CODE,
    ANY_VALUE ( a.AD_CODE ) AS AD_CODE,
    ANY_VALUE ( a.ADMIN_ADNM ) AS ADMIN_ADNM,
    ANY_VALUE ( a.NATURAL_ADNM ) AS NATURAL_ADNM,
    ANY_VALUE ( a.PCHARGE_CODE ) AS PCHARGE_CODE,
    ANY_VALUE ( a.CHARGE_TYPE ) AS CHARGE_TYPE,
    ANY_VALUE ( a.CHARGE_LEVEL ) AS CHARGE_LEVEL,
    ANY_VALUE ( a.PCOUNT ) AS PCOUNT,
    ANY_VALUE ( a.FLDAREA ) AS FLDAREA,
    ANY_VALUE ( a.PCHARGE_NAME ) AS PCHARGE_NAME,
    ANY_VALUE ( a.MOBILE ) AS MOBILE 
FROM
    vw_village_warn_people a 
WHERE
    a.PREV_CODE = prevCode 
GROUP BY
    a.mobile;