Millionaire Mode

SQL Aggregates and Subqueries

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)...

  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

Prize Money

15₹7 Crores
14₹1 Crore
13₹50,00,000
12₹25,00,000
11₹12,50,000
10₹6,40,000
9₹3,20,000
8₹1,60,000
7₹80,000
6₹40,000
5₹20,000
4₹10,000
3₹5,000
2₹2,000
1₹1,000