GATE | GATE-CS-2017 (Set 1) | Question 19

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.

g20172_4

The output of executing the SQL query is _______.

Note: This questions appeared as Numerical Answer Type.
(A) 1.2
(B) 2.3
(C) 2.6
(D) 3.1


Answer: (C)

Explanation: Output of Query will be:


DeptName     Number

AA             4

AB             3

AC             3

AD             2

AE             1

4 + 3 + 3 + 2 + 1 = 13 / 5 = 2.6

Therefore, option C is correct

Quiz of this Question

My Personal Notes arrow_drop_up