Page 108 - PYTHON-12
P. 108

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, 'I')





               v)  Give the output of the following:
               (a) Select MIN(AVERAGE) from GRADUATE where SUBJECT="PHYSICS";

                 MIN(AVERAGE)


                 63



                (b) Select SUM(STIPEND) from GRADUATE WHERE div='II';

                 SUM(STIPEND)


                 800
   103   104   105   106   107   108   109   110   111   112   113