Which of the following is the query that will create a report that will display the following: FIRTSNAME, SALARY with additional 1000 in employees salary, rename this column as BONUS, then get the DEPARTMENT_NAME and DEPARTMENT_ID Join the table using ON condition

Answer

SELECT FIRSTNAME, SALARY + 1000 AS BONUS, DEPARTMENT_NAME, DDEPARTMENT_IDFROM EMPLOYEES E JOIN DEPARTMENTS DON EDEPARTMENT_ID = DDEPARTMENT_ID;