SELECT
    MEMBER_CODE as CODE,
    LAST_NAME as L_NAME,
    FIRST_NAME as F_NAME
FROM
    MEMBER_MST
ORDER BY MEMBER_CODE DESC;