📚 Practice Mode

SQL Aggregates and Subqueries

Learn at your own pace with hints and detailed explanations

1 / 15
Multiple Choice

Select a query to display the department wise average salary.

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

  1. select avg(SAL) from EMP grouped by DEPTNO;
  2. select avg(SAL) from EMP group by DEPTNO;
  3. select avg(SAL) from EMP grouping with DEPTNO ;
  4. select avge(SAL) from EMP group by DEPTNO;
  5. none of these
Change Mode