Page 111 - IPP-12-2025
P. 111
(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
