根据下面的代码，MySQL如何实现查询要求

这样的话SQL有两种写法：
法一

SELECT e.EMPLOYEE_NAME AS `姓名`, 
        d.DEPARTMENT_NAME AS `部门号`,
        e.SALARY AS `工资`
    FROM DEPARTMENTS AS d, EMPLOYEES AS e
    WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID 
    ORDER BY d.DEPARTMENT_ID DESC, SALARY ASC

法二

SELECT e.EMPLOYEE_NAME AS `姓名`, 
        d.DEPARTMENT_NAME AS `部门号`,
        e.SALARY AS `工资`
    FROM EMPLOYEES AS e
    LEFT JOIN DEPARTMENTS AS d
    ON e.DEPARTMENT_ID = d.DEPARTMENT_ID
    ORDER BY d.DEPARTMENT_ID DESC, SALARY ASC