Page 109 - PYTHON-12
P. 109

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

                  COUNT(distinct SUBJECT)


                  4


                (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


               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
   104   105   106   107   108   109   110   111   112   113   114