Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order to display the employees lastname concatenated to salary. Format the salary column to 6 character long right padded with =E2=80=98*' as special character for all employees whose manager_id is null or salary between 4000 and 6000 Rename the column as employees and their Salaries

• SELECT (FIRSTNAME||RPAD(SALARY,6,'*')) AS "EMPLOYEES AND THEIR SALARIES"FROM EMPLOYEESWHERE MANAGER_ID = NULLOR SALARY BETWEEN 4000 AND 6000;
• SELECT (FIRSTNAME||RPAD(SALARY,6,'*')) AS "EMPLOYEES AND THEIR SALARIES"FROM EMPLOYEESWHERE MANAGER_ID IS NULLOR SALARY BETWEEN 4000 OR 6000;
• SELECT (FIRSTNAME||RPAD(SALARY,6,'*')) AS "EMPLOYEES AND THEIR SALARIES"FROM EMPLOYEESWHERE MANAGER_ID IS NULLOR SALARY BETWEEN 4000 AND 6000; Correct
• SELECT (FIRSTNAME||(SALARY,6,'*')) AS "EMPLOYEES AND THEIR SALARIES"FROM EMPLOYEESWHERE MANAGER_ID IS NULLOR SALARY BETWEEN 4000 AND 6000;