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 todisplay the Firstname concatenated to employees original salary plus concatenate again a new column salary that multiplies the original salary into three. Rename the column as Dream Salaries.Note sort the salary in descending order.
SELECT (FIRSTNAME||' EARNS '|| SALARY || 'MONTHLY BUT WANTS' || SALARY * 3)AS "DREAM SALARIES"FROM EMPLOYEESORDER BY SALARY;
SELECT (FIRSTNAME||' EARNS MONTHLY BUT WANTS' || SALARY * 3)AS "DREAM SALARIES"FROM EMPLOYEESORDER BY SALARY DESC;
SELECT (FIRSTNAME||' EARNS '|| SALARY || 'MONTHLY BUT WANTS' || SALARY * 3)AS "DREAM SALARIES"FROM EMPLOYEESORDER BY SALARY DESC;Correct
SELECT (FIRSTNAME||' EARNS MONTHLY BUT WANTS' || SALARY * 3)AS "DREAM SALARIES"FROM EMPLOYEESORDER BY SALARY;