Page 101 - IPP-12-2024

(c). Select COUNT(distinct SUBJECT) from GRADUATE;

Average(Stipend)

450

(d). Assume that there is one more table GUIDE in the database as shown below:
Table: GUIDE

MAINAREA ADVISOR

PHYSICS VINOD
COMPUTER SCIENCE ALOK
CHEMISTRY RAJAN

MATHEMATICS MAHESH

(e). What will be the output of the following query:

SELECT NAME, ADVISOR FROM GRADUATE, GUIDE WHERE SUBJECT= MAINAREA;

Name Advisor

Karan Vinod

Diwakar Alok
Divya Rajan

Rekha Vinod
Arjun Mahesh

Sabina Rajan

John Vinod
Robert Mahesh

Rubina Alok

Vikas Mahesh