Multiple choice

Select a query to display the average and sum of salaries for all employees.

Consider the following relation schema:
 EMP(ENAME,EMPNO,SAL,COMM,DEPTNO,JOB,MGR,HIREDATE);

  1. select average(SAL), sum(SAL) from EMP;

  2. select avge(SAL), sum(SAL) from EMP ;

  3. select avg(SAL), summation(SAL) from EMP;

  4. select average(SALARY), sum(SAL) from EMP;

  5. none of these
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Yes, none of the answer is correct.

Keep practicing — related questions