#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)
Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 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;