SELECT
    AGE AS AGE
    , GENDER_CODE AS GENDER
    , AVG(AVERAGE_VALUE) AS H_AVG
    , SUM(COUNT(*)/ AS H_PER
    , GENDER_CODE AS GENDER
FROM
    EMP 
WHERE
    EMP_ENG_NAME LIKE '%s%s%' 
ORDER BY
    EMP_CODE ASC;