Consider a database that has the relation schema Student (ID, Name, and Course). An instance of the schema EMP and a SQL query on it are given below:
|
ID |
Name |
Course |
|
1001 |
STA |
Compiler |
|
1002 |
STB |
Computer Networks |
|
1003 |
STC |
Computer Architecture |
|
1004 |
STD |
Compiler |
|
1005 |
STE |
Computer Networks |
|
1006 |
STF |
Computer Architecture |
|
1007 |
STG |
Computer Networks |
|
1008 |
STH |
Compiler |
|
1009 |
STI |
Computer Networks |
|
1010 |
STJ |
Computer Architecture |
|
1011 |
STK |
Compiler |
|
1012 |
STL |
Computer Networks |
|
1013 |
STM |
Computer Architecture |
|
1014 |
STN |
Compiler |
|
1015 |
STP |
Computer Networks |
SELECT AVG(ST.X)
FROM ST
WHERE (Course, X) IN
(SELECT Course, COUNT(ID) AS
ST(Course, X)
FROM Student
GROUP BY Course)
What is the output of the above SQL query?
Enter numerical value using the virtual keypad. Round off where necessary.