Page 368 - Informatics_Practices_Fliipbook_Class12
P. 368

(iv)  To add 1000 in modulus of 30/4.
            (v)  To retrieve the string '    Unity Is Strength    '  in lowercase after removing all leading and trailing spaces.

                                                           OR
             Based on the DOCTOR table, write SQL statements to perform the following operations:

                                                      Table: DOCTOR

                   ID          NAME           DEPT               SEX           EXPERIENCE     DATE OF JOIN

                  101       John          ENT                     M                 12       12-04-2000

                  104       Smith         Orthopedic              M                 5        23-09-2014

                  107       George        Cardiology              M                 10       14-05-2005
                  114       Lara          Skin                    F                 3        28-07-2018

                  109       K George      Medicine                F                 9        18-03-2003

                  105       Johnson       Orthopedic              M                 10       18-04-2005

            a.  Display names which contain the word "GEORGE".
            b.  Display day name of date of join of employees of ENT department.

            c.  Display number of male and female employees.
            d.  Display names of doctors in lower case.

            e.  Display names of those employees whose year of who have joined after the year 2020.
        34.   Simplified Learning consultant is opening its new office in Chennai. The new office is spread in three buildings as
            shown below:



                                           Alpha Block               Beta Block




                                                      Gamma Block



             Distances between various buildings are as follows:

             Alpha to Beta Block      65m

             Alpha to Gamma Block     120m

             Beta to Gamma Block      145m

             Number of computers:

             Alpha Block               125

             Beta Block                60

             Gamma Block               50




          354  Touchpad Informatics Practices-XII
   363   364   365   366   367   368   369   370   371   372   373