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

