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.

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation