Gate2017 cs Q30

0. Consider 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

Answer
Comment
Array

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.