Page 288 - Information_Practice_Fliipbook_Class11
P. 288

(ii)  Display records of those customers that have more than 2 persons travelling.

              (iii)  Display the names and dates of travel of customers in ascending order of TRAVELDATE
              (iv)  Display the number of customers travelling to each destination.
              (v)  Display the CNAME and TRAVELDATE of employees whose travelling distance is between 200 and 500 kms.
              (vi)  Change the destination to GANGTOK for customer whose CID is 106.
              (vii)  Display the names of customers whose names begin with 'S'.
              (viii) Delete the records of customers whose destination is not known.
         Ans.  (i)   SELECT CNAME FROM TRAVEL WHERE CAT="HILL STATION";
              (ii)  SELECT * FROM TRAVEL WHERE NPERSONS>2;

              (iii)  SELECT CNAME, TRAVELDATE FROM TRAVEL
                  ORDER BY TRAVELDATE;
              (iv)  SELECT DESTINATION, COUNT(*) FROM TRAVEL

                  GROUP BY DESTINATION;
              (v)  SELECT CNAME, TRAVELDATE FROM TRAVEL
                  WHERE DISTANCE BETWEEN 200 AND 500;
              (vi)  UPDATE TRAVEL
                  SET DESTINATION="GANGTOK"

                  WHERE CNO=106;
              (vii)  SELECT CNAME FROM TRAVEL

                  WHERE CNAME LIKE "S%";
              (viii) DELETE FROM TRAVEL

                  WHERE DESTINATION IS NULL;
          16.  Refer to table given in question no. 9 and write the output for the following queries:
              (i)  SELECT MIN(TRAVELDATE) FROM TRAVEL;

              (ii)  SELECT CNAME, TRAVELDATE,DESTINATION FROM TRAVEL
                  WHERE NPERSONS<3 AND CAT IS NULL;
              (iii)  SELECT AVG(DISTANCE) FROM TRAVEL
                  WHERE TRAVELDATE BETWEEN "2022-01-01" AND "2022-06-30";
              (iv)  SELECT CAT,SUM(DISTANCE) FROM TRAVEL
                  GROUP BY CAT

                  HAVING CAT !="NULL"
              (v)  SELECT CNAME, TRAVELDATE FROM TRAVEL

                  ORDER BY TRAVELDATE;
              (vi)  SELECT DESTINATION, COUNT(*) FROM TRAVEL
                  GROUP BY DESTINATION;
              (vii)  SELECT CNAME, TRAVELDATE FROM TRAVEL

                  WHERE DISTANCE BETWEEN 200 AND 500;
              (viii) SELECT CNAME FROM TRAVEL

                  WHERE CNAME LIKE "S%";
         Ans.  (i)   +-----------------+               (ii)   Empty Set
                  | MIN(TRAVELDATE) |
                  +-----------------+
                  | 2022-01-01      |
                  +-----------------+
          274  Touchpad Informatics Practices-XI
   283   284   285   286   287   288   289   290   291   292   293