Multiple choice

Select a query to display the average commission of employees.

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

  1. select avg(COMM) from EMP;

  2. select avg(COMM) from EMP where COMM is not NULL ;

  3. select avge(COMM) from EMP;

  4. select avg(COMM) from EMP where COMM not NULL ;

  5. options 1 and 2
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The query of option 1 and 2 , both will fetch the  correct data.

Keep practicing — related questions