Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 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

Answer

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