#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 Job_id and add the ff: function:Count the total number of job_id per distinct values; Compute for the summary of salary per job_id; and Compute for the average salary per job_id
Answer
SELECT DISTINCT(JOB_ID), COUNT(JOB_ID) AS =E2=80=9CNO OF JOB_ID=E2=80=9D, SUM(SALARY) AS =E2=80=9CTOTAL SALARY=E2=80=9D, AVG(SALARY) AS =E2=80=9CAVERAGE SALARY=E2=80=9D FROM EMPLOYEES GROUP BY JOB_ID;