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

