SELECT
      EMP_CODE AS CODE
    , EMP_LAST_NAME AS SURNAME
    , EMP_FIRST_NAME AS NAME
FROM
    EMP
     INNER JOIN jobs ON jobs.id = players.job_id;

ORDER BY
    TOTAL_VALUE DESC;
;