SQL Aggregates and Subqueries
Casual Mode - Take your time!
1 / 15
Correct
0
Incorrect
0
Score
0%
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)...
- select avg(SAL) from EMP grouped by DEPTNO;
- select avg(SAL) from EMP group by DEPTNO;
- select avg(SAL) from EMP grouping with DEPTNO ;
- select avge(SAL) from EMP group by DEPTNO;
- none of these