Page 100 - IPP-12-2024

ii) Display a report, listing NAME, STIPEND, SUBJECT and amount of stipend received in a year
assuming that the STIPEND is paid every month.

(iii) To count the number of students who are either PHYSICS or COMPUTER Sc. graduates.

iv)To insert a new row in the GRADUATE table: 11,"KAJOL", 300,
"computer sc", 75, 1)

v)Give the output of the following:

(a.) Select MIN(AVERAGE) from GRADUATE where SUBJECT="PHYSICS";

(b). Select SUM(STIPEND) from GRADUATE WHERE div=2;