SQL Aggregates and Subqueries

Time: 00:00:00

Attempted

Not Attempted

Marked For Review

Attempted & Reviewed

Question 1 of 15

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 Your Answer:

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

Mark for Review

Attempted

Not Attempted

Marked for Review

Attempted & Reviewed

Current