SELECT
    *
FROM
    (
    SELECT ROWNUM
        ID,
        T.EQUIVALENCYSUBJECTID,
        T.MAPPINGTEMPORARYID,
        T.NEWINDEXPOINT,
        T.STUDENTID,
        ST.FULLNAME,
        S.CREDIT,
        M.SUBJECTCODE,
        S.SUBJECTNAME,
        SUBSTR( S.ADMITSCHOOLYEAR, 2, 1 ) AS SEMESTERALL,
        'NEW'
    FROM
        EQUIVALENCYMAPPINGTEMPORARY T
        LEFT JOIN MASTERDATA.STUDENT ST ON ( T.STUDENTID = ST.STUDENTID )
        LEFT JOIN EQUIVALENCYSUBJECTMAPPING M ON ( T.EQUIVALENCYSUBJECTID = M.EQUIVALENCYSUBJECTID AND ST.STUDYPROGRAMID = M.STUDYPROGRAMID )
        LEFT JOIN SUBJECTS S ON ( M.SUBJECTID = S.SUBJECTID AND M.SUBJECTCODE = S.SUBJECTCODE AND M.STUDYPROGRAMID = S.STUDYPROGRAMID )
    WHERE
        T.STUDENTID = '104022380339'
        AND T.NEWINDEXPOINT IS NOT NULL
        AND S.SUBJECTCODE IN('EAJ1E4', 'EAJ4A2')
    )
ORDER BY
    SEMESTERALL ASC,
    SUBJECTNAME ASC