Gate2017 cs Q30

30Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName). An instance of the schema EMP and a SQL query on it are given below.

EMP
EmpId	Emp Name	Dept Name
1.	XYA	AA
2.	XYB	AA
3.	XYC	AA
4.	XYD	AA
5.	XYE	AB
6.	XYF	AB
7.	XYG	AB
8.	XYH	AC
9.	XYI	AC
10.	XYJ	AC
11.	XYK	AD
12.	XYL	AD
13.	XYM	AE

SELECT AVG (EC.Num)
FROM EC
WHERE(DeptName, Num)IN
(SELECT DeptName, COUNT(EmpId)AS
EC(DeptName,Num)
FROMEMP
GROUP BY DeptName)

The output of executing the SQL query is _____.

Note – Numerical Type question

Option : A
Explanation :
EC
Dept Name Num
AA 4
AB 3
AC 3
AD 2
AE 1

Avg(NUM) = 13/5 = 2.6

Forgot your password?

I agree with the Terms.