Skip to content
Related Articles

Related Articles

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

View Discussion
Improve Article
Save Article
Like Article
  • Last Updated : 28 Jun, 2021

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
Recommended Articles
Page :

Start Your Coding Journey Now!