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.
The output of executing the SQL query is _______.
Note: This questions appeared as Numerical Answer Type.
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
Please Login to comment...