#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)
Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESWhich of the following is the correct query that display the maximum lastname concatenated to firstname and rename the column as "Employees Name", Job_id and apply the ff functions:Count the Job_id; Apply where condition whose lastname ends with letter =E2=80=98N'; Group the job_id; and Apply having clause of employees having average salary that is greater than 10000
Answer
SELECT MAX(LASTNAME||FIRSTNAME) AS "EMPLOYEES NAME", JOB_ID, COUNT(JOB_ID)FROM EMPLOYEESWHERE LASTNAME LIKE '%N'GROUP BY JOB_IDHAVING AVG(SALARY)>10000;